help on formula.
Options
Trish Dillon
✭✭✭✭✭✭
trying to get this formula to work. NO LUCK please advise
=IFERROR(WORKDAY(INDEX({delaware}, MATCH([Calendar Year]@row, {year}, 0)), {Holiday}, "")
Tags:
Best Answer
-
it still gives me saturdays
=IFERROR(WORKDAY(INDEX({delaware}, MATCH([Calendar Year]@row, {year}, 0)), 0, {Holidays}), "")
Answers
-
it still gives me saturdays
=IFERROR(WORKDAY(INDEX({delaware}, MATCH([Calendar Year]@row, {year}, 0)), 0, {Holidays}), "")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!