Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Re: Assign a due date of Thursday for all items due in a certain week

52 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi - I’m trying to set a due date that is two weeks out from a publish date on the nearest Thursday. Essentially, everything that is set to be published in week 25, should be due the Thursday of week 23. Does anyone have any hot tips on how to formulate this one?

1 Reply 1

Hi and welcome @Joan_Born!

This should work for you

IF(
    {Date field},
    DATEADD(DATEADD({Date field},-2,'weeks'),4-WEEKDAY({Date field}),'days')
    )