Put May 2006 in A1, then put this formula in A2 and copy down
=DATE(YEAR($A$1),MONTH($A$1),1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR($A$1),MONTH($A$1),8-5))
this assumes that when you put May 2006 in A1 it will show as 5/1/2006 or
whatever region setting your date formats use
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Carla" wrote in message
...
I would like my spreadsheet to tell me what the dates are for the Thursdays
in a specified month. i.e - I will input May 2006, I would like it to
then
show me each Thursday, each in their own cell. 1st Thurs=05/04/06, 2nd
Thurs=05/11/06, etc.
Thank you,
Carla