Figuring number of Mon. Tues. Wed between dates
nevermind on this part :), but i stand by the A151 to B1 correction :)
--
** John C **
"John C" wrote:
and of course, the =2 needs to be changed to =3, where 3=Tuesday :)
--
** John C **
"T. Valko" wrote:
One way...
A1 = start date
B1 = end date
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A151)),2)=2))
Where =2 means the 2nd day of the week = Tuesday
--
Biff
Microsoft Excel MVP
"Paula" wrote in message
...
Course begins January 1, 2008
Course ends May 30, 2008
How many Tuesdays are there. Of course the dates will change.
Thanks
|