Assigning due dates to release dates - HELP please

[Helen_Demoz]

I’m hoping someone can help me figure this out.

Is there a way to link a number of due dates to a number of master release dates? For each release date, there will be a number of due dates that tie-in to that particular release date. The due dates for each release date generally never change (though there are a few exceptions that I don’t want to focus on).

As of now, every time a release date moves, I have to manually change the corresponding due dates in different fields.

I would like to assign a number of due dates to a number release dates. When I assign a release date in a field, I would like the corresponding due dates to change so that they reflect the dates that correspond with the release date.

Is there a way to accomplish this without having to manually change due dates in each field?

[Andy_Lin1]

This is how you’d get the Thursday of the same week for any given date:
DATEADD(Date,4-WEEKDAY(Date),'days')

So, putting this formula together with yours, you’d get:
DATEADD(DATEADD({Release Date},-4,'weeks'),4-WEEKDAY({Release Date}),'days')

Note that you don’t need to sub in your formula into the WEEKDAY function, because DATEADD with ‘weeks’ always returns the same day of the week.

Formula modified from:
https://exceljet.net/formula/get-first-monday-before-any-date

Note: Airtable’s WEEKDAY function is not compatible with Excel.

[James_Nonu-Carl]

Fantastic, thank you so much Andy - that worked a charm.