Date Fill

[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

 

[Niek Otten]

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
|

 

[Leo Heuser]

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 A11
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 C11 with the fill handle
(The little square in the lower right corner of the cell).

 

[VBA Noob]

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


VBA Noo

 

[Syed Haneef]

"martins" <[email protected]> skrev i
en
meddelelse news:[email protected]...

Hi Martins

One way:

1. Select A11
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 C11 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

 

[Leo Heuser]

"Syed Haneef" <[email protected]>
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]

Works fine Leo - thank you very much for help and all other that
replied

martins

 

[Leo Heuser]

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