Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Dec 17, 2021
Having issues coming up with the following formula need.
I have a “Delivery Date” field with a date. I have another field where the forumla will be “Settlement Date”
The Settlement Date needs to look at the Delivery Date and then automatically calculate next weeks Friday date.
Issue is the work week is Monday-Sunday and pay day, or “Settlement Date”, is the next week on a Friday.
Example 1. Delivery Date = Sunday 12/12/21 then Settlement Date = 12/17/21
Example 2. Delivery Date = Monday 12/13/21 then Settlement Date = 12/24/21
Dec 19, 2021
this would be the formula for the date of next Friday based on today: