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

In B1:

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

Fill right

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"martins" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
|
| 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" <(E-Mail Removed)> skrev i en
meddelelse news:(E-Mail Removed)...
>
> 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 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.

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


VBA Noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56858

Leo Heuser Wrote:
> "martins" <(E-Mail Removed)> skrev i
> en
> meddelelse news:(E-Mail Removed)...
> >
> > 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 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


--
Syed Haneef
------------------------------------------------------------------------
Syed Haneef's Profile: http://www.excelforum.com/member.php...o&userid=37126
View this thread: http://www.excelforum.com/showthread...hreadid=568582

"Syed Haneef" <(E-Mail Removed)>
skrev i en meddelelse
news:(E-Mail Removed)...
>
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
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=568582

"martins" <(E-Mail Removed)> skrev i en
meddelelse news:(E-Mail Removed)...
>
> 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