It worked I changed the A151 to A2 which is where I have the end date. Thanks
so much.

"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