Date Calculation problem
Thanks,
It worked out fine.
"Jacob Skaria" wrote:
Use the DATE() function. With the date in A1 and number of months in B1 try
the below formula in C1. Copy down as required...
In C1
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))
If this post helps click Yes
---------------
Jacob Skaria
"wins007" wrote:
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
|