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
Page 1 / 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:
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)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.