Hi Bob!

I've seen this formula before. I'm sure it works but I
haven't tried it out yet. But just looking at it I would
like to know the logic behind 4+ and +35.

Biff

-----Original Message-----
Here is a way that doesn't need both dates, and A1 can
hold any date in the
month

=4+(DAY($A$1-DAY($A$1)+35)<WEEKDAY($A$1-DAY($A$1)-C1))

where C1 holds the day number (1 =Mon, 2=Tue), etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Biff" wrote in message
...
Hi!

Here's one way:

A1 = 2/1/2005
A2 = 2/28/2005

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=X))

Where X = 1 through 7 for Monday through Sunday

Biff

-----Original Message-----
If I put 01.02.2005 in Cell for Feb, 2005, How can I
calculate total no. of
days i.e. total Sundays, total Mondays, total Tuesdays
etc. in that month?
Ajit
--
Knowldege is Power
.



.