=4+(DAY(D1-DAY(D1)+35)<WEEKDAY(D1-DAY(D1)-2))-SUMPRODUCT(--(TEXT(holidays,"y
yyymm")=TEXT(A1,"yyyymm")),--(WEEKDAY(holidays)=2))
where A1 holds a date in the month being tested, holidays is a range of
holiday dates.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"harnagel" wrote in
message ...
Here's my columns:
Date Day (calculated formula) Data
11/1 Mon xyz
11/1 Mon xyz
11/2 Tue xyz
11/3 Wed xyz
11/4 Thur xyz
11/7 Mon xyz
11/14 Mon xyz
I would like to count how many Mondays were worked in a month (minus
Holidays if possible).
Thanks.
--
harnagel
------------------------------------------------------------------------
harnagel's Profile:
http://www.excelforum.com/member.php...o&userid=29376
View this thread: http://www.excelforum.com/showthread...hreadid=490858