Trying to create start and end dates for a task based on initial date field and duration being completed

Topic Labels: Formulas
826 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I want the start date to be the initialized date of the task plus 1 day. The end date should be the start date plus whatever number is entered in the duration field.

I was trying to use IF plus DATEADD to first check if there was data in the initialized and duration fields, then proceed to auto fill the start and end field.

Any help is appreciated!

1 Reply 1

This really messes up a ton of people, but the most important thing to know about the formula field in Airtable is that it only supports straight quotes, not stylized quotes.

Note that your quotes are stylized.

Notice the extremely subtle difference between ’ and '

Hopefully someday, the Airtable team will improve the formula field to not choke on stylized quotes. But in the meantime, we have to be vigilant about spotting this ourselves.