How can a calculate a due date based on weeks?
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
Answers
-
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".
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!