Help

Duration field and formula

Topic Labels: Formulas
461 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Celine_Derai
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I am trying to add a duration field in my base and I want the end date to be calculated based on the duration I am inputing. How can I do that?
Also, I would like to be able to change the duration whenever I need to and it so reflects the end date accordingly.

Thank you for your help!

Celine

2 Replies 2

Hi @Celine_Derai - you can do this with two methods depending upon what you are trying to achieve. You can use DATEADD to add a number of days to a start date or use WORKDAY if you want to ignore weekends:

Screenshot 2021-04-23 at 22.30.55

Formulas are:

DATEADD(Start, {Duration (days)}, 'days')

and

WORKDAY(Start, {Duration (days)})

Celine_Derai
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much @JonathanBowen This is exactly what I needed.