Got it! Thanks Bob.
Biff
-----Original Message-----
Hi Biff,
The 4 is the base point, every month will have at least 4
instances of each
day in that month.
The 35 is used (5 weeks x 7 days) to get outermost 5 week
date from teh
start of the month, which is then compared to the weekday
of the last day of
the previous month less the day number being checked. If
this is True, it
has the effect of adding 1 to the base point, that is
identifying if there
are 5.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Biff" wrote in message
...
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
.
.
.
|