Date Calculation problem
"wins007" wrote:
I need to calculate a new date based on an original date Col A
to which I need to add a figure which relates to number of months
to be added Col B to produce a new date Col C.
Test solutions with 1/31/2009 in A and 1 in B; also with 2/29/2008 in A and
12 in B. My guess is: you would like 2/28/2009 for both. In that case,
use either of the following:
=edate(A1,B1)
=min(date(year(A1),B1+month(A1),day(A1)), date(year(A1),1+B1+month(A1),0)
Copy the format of A1 to C1.
EDATE is preferred. If you get a #NAME error, see the EDATE help page. Use
the latter only if you cannot load the Analysis ToolPak.
----- original message -----
"wins007" wrote in message
...
Hi everyone,
I currently have a problem with the calculation of some dates based on an
existing one. I need to calculate a new date based on an original date Col
A
to which I need to add a figure which relates to number of months to be
added
Col B to produce a new date Col C.
A B C
03/15/2009 2 05/13/2009
04/06/2009 3 04/07/2009
02/28/2009 1 03/28/2009
Your valuable help will be welcomed.
Thanks for your usual support
|