Count If for Workdays

Options

Hello,

I have a sheet that has a column with a bunch of different dates on it. I'd like to easily be able to visualize how many of those dates fall within the 1st week of the month, 2nd, 3rd, etc. I'd like to organize it by actual workdays rather than dates. Any suggestions for how to display that data?

One thought is to show how many dates fall within each week of the entire calendar year, and then find a way to display that nicely. The reason is because i'm more interested in the workdays being shown rather than which month they fall into. Most months don't begin and end perfectly on a monday and friday. Any help is much appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!