
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 14, 2021 09:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 23, 2021 02:33 PM
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:
Formulas are:
DATEADD(Start, {Duration (days)}, 'days')
and
WORKDAY(Start, {Duration (days)})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2021 06:39 PM
Thank you so much @JonathanBowen This is exactly what I needed.
