Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autoincrementing dates
I have a column formatted as "Date" with format March-01, etc.
If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. Many thanks. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autoincrementing dates
In A1 enter Jan-08 and drag till u want
it will show only Jan-08, at the end of the cursor u will autofill option click for more option and then choose fill months u will get the result as u need...... On Apr 6, 10:16*am, "Andrew Chalk" wrote: I have a column formatted as "Date" with format March-01, etc. If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. Many thanks. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autoincrementing dates
Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk
: I have a column formatted as "Date" with format March-01, etc. If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. There are many ways, and this may or may not be the simplest, but I have just tested it and I know it works: 1. Enter 1-1 in A1. (Excel will convert that to some form of 1 January 2008.) 2. Enter =DATE(YEAR(A1),MONTH(A1)+1,1) in A2. 3. Highlight both cells and custom format as mmm-yy. 4. Hightlight A2 only, and use the fiull handle to drag down the desired number of months. Both the formula and the format will propagagte. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autoincrementing dates
Hi Andrew,
Right Click on the fill handle and drag down as far as you need when you let go of the right button at the bottom you will be given a Menu of options. Left click on the one you want which in this case will be Fill Months. HTH Martin "Andrew Chalk" wrote in message ... I have a column formatted as "Date" with format March-01, etc. If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. Many thanks. |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Autoincrementing dates
Hi,
There are a couple of other ways that are quite good to use as well: =EDATE(A1,1) =EOMONTH(A19,0)+1 edate gives you the next month and eodate gives you the last day of the month (0=current) and then you add one to get the first day of the next month. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Stan Brown" wrote: Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk : I have a column formatted as "Date" with format March-01, etc. If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. There are many ways, and this may or may not be the simplest, but I have just tested it and I know it works: 1. Enter 1-1 in A1. (Excel will convert that to some form of 1 January 2008.) 2. Enter =DATE(YEAR(A1),MONTH(A1)+1,1) in A2. 3. Highlight both cells and custom format as mmm-yy. 4. Hightlight A2 only, and use the fiull handle to drag down the desired number of months. Both the formula and the format will propagagte. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autoincrementing dates
Thanks everyone for your help. All of these methods seem to work.
Regards, Andrew "Andrew Chalk" wrote in message ... I have a column formatted as "Date" with format March-01, etc. If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autoincrementing dde link | Excel Discussion (Misc queries) | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |