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


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

Date Fill
 

In B1:

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

Fill right

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"martins" wrote in message
...
|
| 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
|

Date Fill
 

"martins" skrev i en
meddelelse ...

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 Fill
 

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


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568582

Date Fill
 

Leo Heuser Wrote:
"martins" skrev i
en
meddelelse ...

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
------------------------------------------------------------------------
Syed Haneef's Profile: http://www.excelforum.com/member.php...o&userid=37126
View this thread: http://www.excelforum.com/showthread...hreadid=568582

Date Fill
 

"Syed Haneef"
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

Date Fill
 

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

Date Fill
 

"martins" skrev i en
meddelelse ...

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