Create a due date
Is it possible to create a due date for the first Thursday of the next month?
For example, I want to take a "date completed" and create a due date for the 3rd Thursday of the next month.
Answers
-
Would you like to give a try with the below ADD function in the Due Date column and see if that helps:
=ADD(A2, 3, "Thursday", 1, MONTH(A2), YEAR(A2))
Ø ADD(A2, 3, "Thursday") - This part adds 3 weeks to the date in cell A2 and then ensures that the resulting date is a Thursday
Ø 1, MONTH(A2), YEAR(A2)) - This part sets the month and year of the resulting date to be the next month and the same year as the "Date Completed" in cell A2
With this you should calculate the due date as the 3rd Thursday of the next month based on the "Date Completed" provided in column A
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
Huma
Community Leader
-
I am getting an #UNPARSEABLE Error
-
Hey @Troy Bjelland
Try this. The formula looks intimidating but only because its long. To insure that the Thursday is next month's Thursday the formula has to calculate Day1 of the next month. It does this 4 times in the formula, which significantly increases its length.
=DATE(YEAR([SCBA Inspection]@row), MONTH([SCBA Inspection]@row) + 1, 1) - DAY(DATE(YEAR([SCBA Inspection]@row), MONTH([SCBA Inspection]@row) + 1, 1)) + 22 - WEEKDAY(DATE(YEAR([SCBA Inspection]@row), MONTH([SCBA Inspection]@row) + 1, 1) - DAY(DATE(YEAR([SCBA Inspection]@row), MONTH([SCBA Inspection]@row) + 1, 1)) - 4)
Will this work for you?
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!