Count If for Workdays

JBsmarty

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!

Kleerfyre

If you don't already have this, this link will take you to the formula handbook that Smartsheet has created. It has a lot of good info in it and will give you a great place to start. There is a WORKDAY function in Smartsheet formulas that would be the best place to start.

https://www.smartsheet.com/marketplace/template-sets/formula-handbook