Using workdays and adding holiday reference

Lasse Dupont

Hi Community

I am trying to output only workdays so not Saturdays and Sundays.

On a second note I have a sheet called Holidays with specific holidays I need to exclude in the same formula, via reference another sheet. The holiday sheet is called Holidays and the column where it is located is column 8

But how can I do this easily, something like ....<> ""; WORKDAY...?

This is the formula from the date column

Thanks 😊

Paul Newcome

You are going to end up with something like this...

=WORKDAY([Start Date]@row, ##, {Other Sheet Holidays Column})

Lasse Dupont

Hi Paul,

and thanks

Sorry i did not add the original formula

=IF([SLA Model]@row = "Normal (6 Days)"; ([Send-out date]@row - 6) + " - " + [Send-out time (GMT)]@row; IF([SLA Model]@row = "Fast Track (4 Days)"; [Send-out date]@row - 4; IF([SLA Model]10 = "Emergency (2 Days)"; [Send-out date]@row - 2) + " - " + [Send-out time (GMT)]@row))

Paul Newcome

Where are you trying to incorporate your holidays?

Lasse Dupont

after [Send-out date]@row - 4 -{[Holidays]}

It's fetched from another sheet called holidays via Smartsheet function "Reference another sheet" -> Holidays -> Column 8

Paul Newcome

Try this...

=WORKDAY([Send Out Date]@row; IF([SLA Model]@row = "Normal (6 Days)"; - 6; IF([SLA Model]@row = "Fast Track (4 Days)"; -4; IF([SLA Model]10 = "Emergency (2 Days)"; -2))); {Other Sheet Holiday Range}) + " - " + [Send-out time (GMT)]@row