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
Check out the Formula Handbook template!