OK, I remember, in your first post you said something about Thursdays in one
month, well put this in A2 and copy down

=$A$1+ROWS($A$1:A1)*7-WEEKDAY($A$1-5)

will give you 04/20/06, 04/27/06 and so on


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Carla" wrote in message
...
I did that, and it did give me Thursday dates. Even though I put 04/16/06,
it still gave me dates prior to that. I'm guessing because it is just
giving
me the Thursdays in April. I really need it to tell me ONLY the dates
that
are Thursdays between (and including) the dates of 04/16/05-05/15/05. Can
that be done?

Thank you again,
Carla

"Peo Sjoblom" wrote:

Use the formula I gave you the other day

=DATE(YEAR($A$1),MONTH($A$1),1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR($A$1),MON*TH($A$1),8-5))




put 04/16/06 in A1



put the formula in A2 and copy down and you'll get the Thursdays




--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Carla" wrote in message
...
I need help writing a formula that will tell me what the dates are for
the
Thursdays that fall within a specified time period (i.e.
04/16/06-05/15/06).
I would like each date to fall in it's own cell, so there will either
be 4
dates of 5 dates depending on the specific month long span of time.

Thank you oh genious ones,
Carla