Create macro to sort and count number of weekdays in year

[Davelm]

I am trying to create a macro that will sort and count the number of weekdays in a year, such as follows:

Please Login or Register  to view this content.

I want to be able to automatically count how many Mon., Tue., etc. in the year.

[JBeaucaire]

Assuming you had START and END dates for the range you wanted to "test" for Mondays in A1 and A2, this formula would give you a count of Mondays in that date range:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2))


You should be able to adapt that to the dates you want and the days of the week needed in each cell you create a formula for in your table.

[Davelm]

Thank you, I will definitely try that.