Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
563 1
Showing results for 
Search instead for 
Did you mean: 


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.