What is WORKDAY formula with SLA built in

Nancy Pet

Hello, I'm seeking a way to add in a formula that runs left to right. When a start date is added to kick off a set of activities, the cells on that line calculate +2 days (what I'm calling SLA date/ service level agreement date) AND also makes the date a WORKDAY (no weekends or holidays).

Thank you so much

workday formula.png

workday formula2.png

Nick Korna

Hi @Nancy Pet ,

First of all you'd need a column with holiday dates set up (this can be in another sheet).

If I've understood your pictures correctly in that you'd like the Copy to Editor to be 2 workdays after Wireframe Approved, the formula would be one of the below:

If your holiday dates are hidden on the same sheet in a column called Holidays:

= WORKDAY([Wireframe Approved]@row, 2, [Holidays]:[Holidays])

If your holidays are listed on another sheet, substitute the last part to a cross sheet reference. This is probably better as allows you to simply drag the formula across if you want the same +2 days in other adjacent cells.

Hope this makes sense and helps!

Ray Lindstrom

Hi @Nancy Pet

I would recommend this formula.

=WORKDAY([Date]@row, 2)

Where "[Date]@row" will be replaced with your column name and row reference that you're trying to add workdays to.

Where 2 is the number of Workdays you're trying to add.

Hope this helps!

BRgds,

-Ray

Ray Lindstrom

@Nick Korna,

I didn't see your answer when I submitted one. I must have still been testing my suggestion and writing my post when you submitted yours. Sorry for the duplication.

Nick Korna

@Ray Lindstrom - no problem, it's all good. :)