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.

Calculating Dates - New to Airtable

Topic Labels: Dates & Timezones Formulas
2368 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ocmac
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello all,

Brand new to Airtable and like what I see so far. 

I am trying to calculate a date from two sets of data.  In Excel I would have use Start Date + Duration - 1 to get the End Date.

I thought I would use the Datetime_Format, but I am getting an #error!  I wrote DateTime_Format({Start Date1}+{Duration}-1, 'M/DD/YYYY')

The Start Date1 is formatted as a Date US (9/5/2023)

Duration is a LookUp field pulling from another tab in same base that is formatted as a number.

I know this is probably something simple, but any help would be appreciated.  Also, a good recommendation for Airtable Resources. 🙂

3 Replies 3

Use the DATEADD() formula. You need to specify what unit of time the duration is.

DATEADD({Start Date}, {Duration}, 'minutes')

 

ocmac
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you, I have a date now instead of an error, but it is not the right date.

For example, the first line in image, should be (1/1/2024 + 9) - 1 = 1/9/2024.

I'm not sure what can have gone wrong there but it seems to be subtracting 1 day instead. Try using an intermediary Duration formula field:

{TD Work Days...} - 1

That should equal 8 for the examples you have posted. Then do the DATEADD formula using this field.