How can a calculate a due date based on weeks?

abc1733

I would like to calculate a due date that is 4 weeks before a launch date. The below formula helps me calculate based on days, but I would like the due date to be 4 weeks before the launch date.

=[Launch Date]@row - 28

Toufong Vang

Clarify what you mean by, "I would like to calculate a due date that is 4 weeks before a launch date", because 28 days IS EQUAL TO 4 weeks.

In other words, if LAUNCH DATE is "7/29/2022", then "4 weeks before launch date" IS =[Launch Date]@row - 28 or "07/01/2022". That is to say, did you want the 'the due date is the START' of that week OR did you want 'the due date is the END' of that week?

For example, "If the launch date is 7/29/2022, then I want the due date to be the MONDAY of that week", or "...I want the due date to be the FRIDAY of that week".

abc1733

Hey Toufong! Thank you for your comment. I will clarify! I am trying to calculate the date that the brief is due prior to launch. Briefs are due 4-weeks before the launch date.

So if a launch date (which is a column), is Wednesday August 17, the brief due date is Wednesday July 20 (4 weeks before 8/17.

The due date should always be the same day of the week as the launch date.