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