FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL

S

SorianoP

I need to create a formula to increment the date on a column by 25 months
on another column
 
F

Franz Verga

SorianoP said:
I need to create a formula to increment the date on a column by 25
months on another column
Click to expand...

Hi SorianoP,

try with this:

=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))


where in A1 is your starting date and in A2 the number of months to add to
initial date.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
N

Niek Otten

=DATE(YEAR(A1),MONTH(A1)+25,DAY(A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to create a formula to increment the date on a column by 25 months
| on another column
|
 
Top