Help

Re: Airtable Formula

1163 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Airtablenewbie1
4 - Data Explorer
4 - Data Explorer
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
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

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)