Month Day count

[WD86]

Hi

I'm looking to have a month drop down menu in an excel spreadsheet, I then want it to be able to automatically count the number of each days that occur in that month. Something a bit like this:

[MONTH]

MON TUE WED THU FRI
4 4 4 3 3

It's been a while since I've fiddled around with excel so my brain can't figure it out. Any help would be appreciated.

[Special-K]

With a date in A1
and day numbers 1 to 7 going from A2:G2

in A3
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT($A$1&":"&EOMONTH($A$1,0))))=A2))
and copy across to G3

Source: http://www.mrexcel.com/forum/excel-q...ays-month.html
Post #2 by Aladin