Hi,

Try this. C6 has 1/1/2009 and C7 has 30/9/2009

=SUMPRODUCT(1*(WEEKDAY(ROW(INDIRECT(C6&":"&C7)))={ 1,3,4}))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"afdmello" wrote in message
...
I undertake trainings on sundays, wednesdays and Thursdays.

Is there a way that I can get the number of sundays, tuesdays and
wednesdays from January 2009 to September 30 2009

I use excel 2007

Thanking you

Afd