Formula based on last modified date that skips weekends
Hi there,
I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated).
With that in mind, I was going to build a helper column that looks at the "Last Modified" date and adds 2 days so I can trigger the workflow off of that.
=[Last Modified]@row+2
However, I'd like the formula to be setup so it skips weekends and any holidays that I have setup in the Project Settings for the sheet.
Any help would be greatly appreciated!
~Jaime
Best Answer
-
=WORKDAY([Last Modified]@row, 2)
Answers
-
=WORKDAY([Last Modified]@row, 2)
-
@JamesB So simple. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!