Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Duration field and formula

Topic Labels: Formulas
1091 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.