WOH!!
Thanks a million.
I am amazed at your diligence and desire to help.I tried Ashish',Barry's and
Lars formulas and all returned the same answer which I am certain is right.
Different ways to do the same thing
I am deeply grateful and looking forward to your continued help.
Afd
"Ashish Mathur" wrote in message
...
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