Calculate dates

[Carla]

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


"Carla" <[email protected]> wrote in message
news:[email protected]...
>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