Hi Airtable community, formula specialists!
How can I use:
- A fixed start date (e.g. 07/15/2019)
- A #-of-days to execute estimate (e.g. 7)
to generate an “Est. Delivery Date” that adds a number of days to the start date, treating weekends as “unavailable”?
The acceptance criteria here would be that the forumla returns “07/23/2019” or “07/23/2019 12:00” is fine.
Bonus if the formula can take a decimal rather than an integer for “# Days” for the purpose of supporting half-days. (I’d never get more granular than half-days.)
I’m going to be trying to create this formula myself, but thought the community may want a crack at it, too.