Calculate dates

[Guest]

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

 

[Peo Sjoblom]

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