MAKE Airtable Search Records Formula not retrievin...

[Airtablenewbie1]

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

[Ron_Daniel]

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)