Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format issue | New Users to Excel | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) |