Date Fill

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

"martins" <[email protected]> wrote in message
news:[email protected]...
|
| 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...o&userid=31616
| View this thread: http://www.excelforum.com/showthread...hreadid=568582
|

"martins" <[email protected]> skrev i en
meddelelse news:[email protected]...
>
> 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

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.

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


VBA Noob

Originally Posted by Leo Heuser

"martins" <[email protected]> skrev i en
meddelelse news:[email protected]...
>
> 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

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" <[email protected]>
skrev i en meddelelse
news:[email protected]...
>
Thank you Leo Heuser ... you gave a much clearer solution.
>
> Regards,
> Syed
>
>

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

Regards
Leo Heuser

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

martins

"martins" <[email protected]> skrev i en
meddelelse news:[email protected]...
>
> 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