Help with Dates..

[SeanM]

Hi, I hope someone can help with this...

If I have a month in one cell (eg. May), how can i get
Excel to populate a column with the dates for that
particular month..

(Example:
May <----User inputs

Tuesday May 1 <-----Excel outputs
Wednesday May 2 <-----Excel outputs
....
....)

All the way to the end of the month..

Any help with this is greatly appreciated!!!
Thank-you
Sean

 

[zacemmel]

Sean,

You can probably do this with one formula, but I split it into 2 formulas in the interest of time.

For the first date, use this formula (entered into b1):

=datevalue(a1&" 2002")

The second formula (in the cell below this one) would be:

=b1+1

The custom date format should be:

ddd MMM dd

 

[kinkyparamour]

Click on the cell then put you mouse pointer on the fill handle at the bottom of the cell. Now drag it down and the dates will follow..............

Denny

 

[IML]

with your date in e1, and starting in row1, you could use
=IF(ISERR(($E$1&" "&ROW()&", "&YEAR(NOW()))+0),"",($E$1&" "&ROW()&", "&YEAR(NOW()))+0)

next copy it down 31 rows.


good luck
This message was edited by IML on 2002-05-02 09:37

 

[SeanM]

Thanks for the info...It really helped

Thanks
Sean