FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL

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

SorianoP wrote:
> I need to create a formula to increment the date on a column by 25
> months on another column

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SorianoP" <[email protected]> wrote in message news:[email protected]...
|I need to create a formula to increment the date on a column by 25 months
| on another column
|

Hi Franz,

Thanks for your help...I really appreciate it.

"Franz Verga" wrote:

> SorianoP wrote:
> > I need to create a formula to increment the date on a column by 25
> > months on another column
>
> 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
>
>
>

Thank You very much Niek...

"Niek Otten" wrote:

> =DATE(YEAR(A1),MONTH(A1)+25,DAY(A1))
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "SorianoP" <[email protected]> wrote in message news:[email protected]...
> |I need to create a formula to increment the date on a column by 25 months
> | on another column
> |
>
>
>