Formula based on last modified date that skips weekends

Jaime Ciabattoni

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

JamesB

@Jaime Ciabattoni

=WORKDAY([Last Modified]@row, 2)

JamesB

@Jaime Ciabattoni

=WORKDAY([Last Modified]@row, 2)

Jaime Ciabattoni

@JamesB So simple. Thank you!