Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date manipulation question
Hi, everyone.
I am trying to add several months to a date in a field. Let's say that cell C3 contains the date Aug 1, 2003. In cell D3 I want to add 18 months to that. I can seem to add days but not months. The online help (if you can call it that) isn't much help beyond saying "you can manipulate dates." Thanks in advance for the help. Nikko |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date manipulation question
=DATE(YEAR(C3),MONTH(C3)+18,DAY(C3))
You need to be careful though as adding 18 might end up at the start of a month after, for instance 31 May gives 1st Dec 2005. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "NikkoW" wrote in message e.rogers.com... Hi, everyone. I am trying to add several months to a date in a field. Let's say that cell C3 contains the date Aug 1, 2003. In cell D3 I want to add 18 months to that. I can seem to add days but not months. The online help (if you can call it that) isn't much help beyond saying "you can manipulate dates." Thanks in advance for the help. Nikko |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date manipulation question
Hi
as addition to Bob to prevent this problem you may use: =DATE(YEAR(C3),MONTH(C3)+18,MIN(DAY(C3),DAY(DATE(Y EAR(C3),MONTH(C3)+18+ 1,0)))) -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... =DATE(YEAR(C3),MONTH(C3)+18,DAY(C3)) You need to be careful though as adding 18 might end up at the start of a month after, for instance 31 May gives 1st Dec 2005. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "NikkoW" wrote in message e.rogers.com... Hi, everyone. I am trying to add several months to a date in a field. Let's say that cell C3 contains the date Aug 1, 2003. In cell D3 I want to add 18 months to that. I can seem to add days but not months. The online help (if you can call it that) isn't much help beyond saying "you can manipulate dates." Thanks in advance for the help. Nikko |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Phone Manipulation | Excel Discussion (Misc queries) | |||
data manipulation question | Excel Worksheet Functions | |||
Date Manipulation | Excel Discussion (Misc queries) | |||
Problem with Date Manipulation | Excel Discussion (Misc queries) | |||
csv manipulation question | Excel Discussion (Misc queries) |