=SUM(IF(WEEKDAY(ROW(INDIRECT("$1:$"&enddate-startdate+1))+$F$2-1)=3,1,0))
Change the =3 to 2 for Mondays and 4 for Wednesdays.

This is an **array** formula. After typing the formula, instead of pressing
just ENTER, press CTRL+SHIFT+ENTER.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Paula" wrote:

Course begins January 1, 2008
Course ends May 30, 2008
How many Tuesdays are there. Of course the dates will change.
Thanks