Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Airtable Formula

65 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Hello everyone Please I need help with a formula I have a field of start date, a duration field and an end date field. I need an airtable formula that once I put a start date and the duration of the project (2days) the end date automatically populates. That is I have a project starting 2/1/2023 and my duration is 3 I.e 3days..I want the end date to automatically populate as 5/1/2023
1 Reply 1

I have a series of deadlines for people based on the date an email will be sent. I need the first person to finish their task 12 business days before the send date. That formula looks like this:

WORKDAY({Email Send Date}, -12)
Instead of the -12, you could just have the duration field referenced. So your End Date field would be this formula:
WORKDAY({Start Date}, Duration)