Entering Dates

[John]

I want to be able to enter a date in cell A1 and have the
rest of the days of the month be placed in the other cells
of row 1.
I have been able to do this by entering =A1 in cell B1 and
then entering A1+1, A1+2, A1+3, etc., in the cells of row
1.
Now I want do the same for a six week span, but I need to
recognize 28,30,or 31 day months. What function can I use
make this work.
Thank you John

 

[Niek Otten]

Hi John,

If A1 contains a real Excel date, then your formula will automatically
respect the number ofdays per mont.
BTW, wouldn' it be simpler to enter =A1+1 and copy that to the right?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Arvi Laanemets]

Hi

Into B1 enter formula
=IF(MONTH($A1+COLUMN(A1)-1)=MONTH($A1),$A1+COLUMN(A1)-1,"")
and copy it into range B1:AF1

 

[Ron Rosenfeld]

I want to be able to enter a date in cell A1 and have the
rest of the days of the month be placed in the other cells
of row 1.
I have been able to do this by entering =A1 in cell B1 and
then entering A1+1, A1+2, A1+3, etc., in the cells of row
1.
Now I want do the same for a six week span, but I need to
recognize 28,30,or 31 day months. What function can I use
make this work.
Thank you John

If the dates are in Excel format, it should do so automatically.

What kind of results did you obtain when you tried it?


--ron

 

[Ron Rosenfeld]

I want to be able to enter a date in cell A1 and have the
rest of the days of the month be placed in the other cells
of row 1.
I have been able to do this by entering =A1 in cell B1 and
then entering A1+1, A1+2, A1+3, etc., in the cells of row
1.
Now I want do the same for a six week span, but I need to
recognize 28,30,or 31 day months. What function can I use
make this work.
Thank you John

On second thought, instead of using the formula that you posted, in B1 place
=A1+1 as you did before.

Now select B1 and hover the cursor over the lower right hand corner. The
cursor should change to a cross-hair. When it does so, depress the left mouse
button and 'drag' the selection to the right another forty columns.

This will drag the formula over, but will update the reference so that
C1: =B1+1
D1: =C1+1
E1: =D1+1

etc.

Now then, with a date (in Excel date format) in A1, and with the cells
formatted as a date, Excel should take care of your date logic.


--ron