How do you work how many of each weekday there are in a month?

[dean786]

For example, if I wanted to see how many 'Mondays' there are in March 2016 (there are four), how could I do that? How could I then do this for each day.

[pecoflyer]

Hi and welcome to the board

Have a look at http://www.cpearson.com/excel/DateTimeWS.htm under "Number of Mondays in period"

There are many other known solutions to this problem

(be aware it's an array formula committed with Ctrl+Shift+Enter)

[Kevin UK]

Hi

One way.

A1 = 01/03/2016
A2 = 31/03/2016

Code: Select all

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A1&":"&A2)),"dddd")="Monday"))