Help with Dates..

SeanM · May 2nd, 2002, 10:06 AM

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 · May 2nd, 2002, 10:13 AM

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 · May 2nd, 2002, 10:26 AM

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 · May 2nd, 2002, 10:35 AM

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 · May 2nd, 2002, 10:46 AM

Thanks for the info...It really helped

Thanks
Sean

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 10:06 AM	#1
SeanM New Member Join Date: May 2002 Posts: 3	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

May 2nd, 2002, 10:13 AM	#2
zacemmel Board Regular Join Date: Apr 2002 Location: Redmond, WA Posts: 636	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

May 2nd, 2002, 10:26 AM	#3
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	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

May 2nd, 2002, 10:35 AM	#4
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	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 ]

May 2nd, 2002, 10:46 AM	#5
SeanM New Member Join Date: May 2002 Posts: 3	Thanks for the info...It really helped Thanks Sean