Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
In A1 down are 1st of month real dates formatted as mmm-yy, eg:
Jul-08
Aug-08
etc
In B1 down, I would like to extract the number of weekdays (Mon-Fri)
and in C1 down, the number of Saturdays
for the month/yr listed in col A
Eg for Jul-08 in A1, result in B1: 23, in C1: 4
Thanks
|