Counting Mondays in Date Range
I just noticed a little tiny issue with my function if the last date is a
Monday. Try this:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A26)),1)={2}))
I changed the second to last 2 to a one and it seemed to work...
Regards,
Ryan--
--
RyGuy
"nospaminlich" wrote:
Thanks a lot for the very helpful replies.
|