Using workdays and adding holiday reference


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 😊


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!