| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Date Increase by 12 Months
I am a fairly new user. In field A1 I have the date 12/1/08. Is there a
formula that would automatically add "12" months to A1 and place the results in A2 (12/1/009)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Date Increase by 12 Months
hi,
This =DATE(YEAR(A1),MONTH(A1)+12,DAY(A1)) or this =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Mike "Steve 084" wrote: I am a fairly new user. In field A1 I have the date 12/1/08. Is there a formula that would automatically add "12" months to A1 and place the results in A2 (12/1/009)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Date Increase by 12 Months
Worked like a charm. Thank you Mike for your help.
"Mike H" wrote: hi, This =DATE(YEAR(A1),MONTH(A1)+12,DAY(A1)) or this =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Mike "Steve 084" wrote: I am a fairly new user. In field A1 I have the date 12/1/08. Is there a formula that would automatically add "12" months to A1 and place the results in A2 (12/1/009)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| Measuring growth-how much did revenue increase using 12 months of | Excel Discussion (Misc queries) | |||
| how do I forecast a 15% increase over 7 months? | Excel Discussion (Misc queries) | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
Linear Mode
