Date add 35 days

Julie Still

I am looking to enter a date 04/02/2020 and then add 35 days. All of our projects have a deadline of 35 to close. Would love any help.

Andrée Starå

Try this.

=[Event Date]@row + 35

Andrée Starå

Hi Julie,

Try something like this in another date column.

=Date@row + 35

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Julie Still

Sorry, not working.

Andrée Starå

Try this.

=[Event Date]@row + 35

Julie Still

That worked! Thank you.

Andrée Starå

Excellent!

Happy to help!

BRYAN BRAY

can you do this but with parameter? like if check box in row is checked, or dropdown is certain item it would change the date to say 30 days instead of 35? Each drop down item would have a different quantity of days requirement

Andrée Starå

Hi Bryan,

@BRYAN BRAY

Was it something like this you had in mind?

We'd add the formula below in the "main" date column.

=IF([Checkbox Column]@row = 1; [Date To Add From]@row + 30)

The same version but with the below changes for your and others convenience.

=IF([Checkbox Column]@row = 1, [Date To Add From]@row + 30)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!