Hi Biff,
When I tried your original formula, it counted the number of a particular
day between those dates, whereas I read the OP to say the number in the
month. Subtle but different by my reading.
Regards
Bob
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Biff" wrote in message
...
Hi Bob!
Versatility!
It doesn't have to be the first and last date of any month!
It could be any two dates.
Biff
-----Original Message-----
This has been bothering me :-). Having to enter two
dates, and the first and
last date of the month is not user friendly IMO (users
make mistakes, lots
of them).
This can probably be done better, but here is an
alternative on Biff's
formula that addresses both issues
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT($A$1-DAY($A$1)
+1&":"&DATE(YEAR($A$1),MON
TH($A$1)+1,0))),2)=X))
X is as defined by Biff
--
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
.
.
|