Is there a way to calculate the last business day of the month? Or the 3rd business day?
I would like to run an automation on the last business day of the month, and on the third business day. is there a way to schedule the automation for that or to create a calculated date field that determines the x business day of the current month?
Thanks for your help!
Sheila
Best Answer
-
Hey Sheila!
Not sure what your data is structured like, but....
If you have a reference sheet with the first day of the month and the last day of the month, you can use the workday function to get the Xth working day of the next month. Like this:
=Workday([FirstDayofMonth]@row-1, X)
with X being that target business date e.g. 3 for the third business day, 4 for the 4th, etc.
To get the last business day of the month, I would use that same reference sheet and do this:
=Workday([LastDayofMonth]@row + 1, -1)
Workday is a pretty helpful formula and can also handle company holidays. More details here: https://help.smartsheet.com/function/workday
Answers
-
Hey Sheila!
Not sure what your data is structured like, but....
If you have a reference sheet with the first day of the month and the last day of the month, you can use the workday function to get the Xth working day of the next month. Like this:
=Workday([FirstDayofMonth]@row-1, X)
with X being that target business date e.g. 3 for the third business day, 4 for the 4th, etc.
To get the last business day of the month, I would use that same reference sheet and do this:
=Workday([LastDayofMonth]@row + 1, -1)
Workday is a pretty helpful formula and can also handle company holidays. More details here: https://help.smartsheet.com/function/workday
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!