|
|
|
|
Once again... Thank you.
"Bob Phillips" wrote:
Assuming the dates are in A1 and B1, this will return the number of Mondays
in January
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)=1),--(MONTH(ROW(INDIRECT(
A1&":"&B1)))=1))
The first = 1 refers to the weekday (1 through 7 for Mon through Sun), the
second refers to the month number.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jon S" <Jon wrote in message
...
do have a twist on the earlier questions and wondered if anyone knows how
to
do it. I'm trying to do the following:
Within a date range (say 1/5/05 to 3/25/05) I would like to identify each
month and further find the number of Mondays, Tuesdays, and etc, within
each
month.
Any thoughts? Thanks for the help,
"Bob Phillips" wrote:
Here is a formula from Daniel M
=SUM(--(WEEKDAY(A2-1+ROW(INDIRECT("1:"&TRUNC(B2-A2)+1)))=C2))
A2, B2 are the 2 dates, C2 is the day of the week (1=Sun, 2=Mon, etc.)
It is an array formula, so commit with Ctrl-Shift-Enter.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"jon s" <jon wrote in message
...
I need a formula or process that allows you to determine the number of
specific days (Mondays, Tuesdays, etc) between two dates.
|