Date Fill

  • Thread starter Thread starter martins
  • Start date Start date
M

martins

I would like to create a spreadsheet where if you input date as Jan06 in
cell
A1, subsequent cells B1 C1 D1 etc automatically fill as
feb06,mar06,apr06 -

Can anyone help
 
In B1:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Fill right

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I would like to create a spreadsheet where if you input date as Jan06 in
| cell
| A1, subsequent cells B1 C1 D1 etc automatically fill as
| feb06,mar06,apr06 -
|
| Can anyone help
|
|
| --
| martins
| ------------------------------------------------------------------------
| martins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31616
| View this thread: http://www.excelforum.com/showthread.php?threadid=568582
|
 
martins said:
I would like to create a spreadsheet where if you input date as Jan06 in
cell
A1, subsequent cells B1 C1 D1 etc automatically fill as
feb06,mar06,apr06 -

Can anyone help

Hi Martins

One way:

1. Select A1:D1
2. Format the cells with the custom format mmmyy
3. In A1 enter 1/1/06
4. In B1 enter the formula
=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
5. Copy B1 to C1:D1 with the fill handle
(The little square in the lower right corner of the cell).
 
Leo said:
"martins" <martins.2c26p2_1154767506.805@excelforum-nospam.com> skrev i
en
meddelelse news:martins.2c26p2_1154767506.805@excelforum-nospam.com...

Hi Martins

One way:

1. Select A1:D1
2. Format the cells with the custom format mmmyy
3. In A1 enter 1/1/06
4. In B1 enter the formula
=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
5. Copy B1 to C1:D1 with the fill handle
(The little square in the lower right corner of the cell).

--
Best regards
Leo Heuser

Followup to newsgroup only please.

Thank you Leo Heuser ... you gave a much clearer solution.

Regards,
Syed
 
"Syed Haneef" <Syed.Haneef.2c28jq_1154769906.3495@excelforum-nospam.com>
skrev i en meddelelse
Thank you Leo Heuser ... you gave a much clearer solution.
Regards,
Syed

You're welcome, Syed, and thanks for the feedback :-)

Regards
Leo Heuser
 
martins said:
Works fine Leo - thank you very much for help and all other that
replied

martins

You're welcome, Martins, and thank you for the feedback.

Leo Heuser
 
Back
Top