NETWORKINGDAYS WITHOUT HOLIDAYS

Options

I need to use a formula to return the working days between TODAY and Oct 7 2024. I used =NETWORKDAYS(TODAY(), DATE(2024, 10, 07), [HOLIDAYS]) and it is unparseable.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!