Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add 18 months
If DOB is in a1; how would you add 18 months to that DOB?
Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add 18 months
Hi Debbie
=DATE(YEAR(J2);MONTH(J2)+18;DAY(J2)) With J2 = DOB Note that my locale use ";" instead of ",". You might have to change this. Wkr, JP "Debbie" wrote in message ... If DOB is in a1; how would you add 18 months to that DOB? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add 18 months
On Oct 18, 10:44*am, "JP Ronse" wrote:
Hi Debbie =DATE(YEAR(J2);MONTH(J2)+18;DAY(J2)) With J2 = DOB Note that my locale use ";" instead of ",". You might have to change this.. Wkr, JP "Debbie" wrote in message ... If DOB is in a1; how would you add 18 months to that DOB? Thanks!- Hide quoted text - - Show quoted text - Awesome, thank you! Works great. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add 18 months
Hi Debbie,
The safest formula is: =MIN(DATE(YEAR(A1),MONTH(A1)+18+{0,1},DAY(A1)*{1,0 })) With this, if the starting month has more days than the end month, and the start day is on the last day of the month, the returned date will be the last day of the month that's 18 months hence. For example, if the start date is 31/August/2008, the returned date would be 28/February/2010. However, a formula like: =DATE(YEAR(A1),MONTH(A1)+18,DAY(A1)) is liable to return a date in the following month in such circumstances. For example, if the start date is 31/August/2008, the returned date would be 3/March/2010. As barry houdini says, you can use EDATE function, but this requires the Analysis ToolPak to be activated in versions before Excel 2007. -- Cheers macropod [Microsoft MVP - Word] "Debbie" wrote in message ... If DOB is in a1; how would you add 18 months to that DOB? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating months with half months. | Excel Discussion (Misc queries) | |||
3 months prior and 3 months post a date | Excel Worksheet Functions | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
converting months to years and months??? | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) |