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.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!