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
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
Thank you Leo Heuser ... you gave a much clearer solution.Originally Posted by Leo Heuser
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks