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