Auto Populate Dates

Jermaine Johnson

Hi Everyone,

I am trying to auto-populate dates based on a certain column, which would update/change/auto-pupulate future dates in other columns within my sheet

Example

IF I put in a date 01/03/2022 in BCA completion date

I would like RR Completion date to auto populate a due date of 01/05/2022 (due within 2 days

I would like the IT Solution date to auto populate a due date of 01/10/2022) due within 7 days from the BCA date)

Andrée Starå

@Jermaine Johnson

Happy to help!

Try something like this.

RR Completion Date

=[BCA Completion Date]@row + 2

IT Solution Date

=[BCA Completion Date]@row + 7

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!