Count the number of cells in a column with a date derived from a workday based on today-1 & holidays

=COUNTIFS([DATE FINISHED],=WORKDAY(TODAY,-1,[HOLIDAYS:HOLIDAYS]))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!