Auto calculate end date

Good Day,

I have a column with start dates and I want to have the column beside it
display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11

How can I do this automatically?

Thanks!
Carol

Lars-Åke
Sun May 11 13:21:11 CDT 2008

On Sun, 11 May 2008 11:04:01 -0700, QPapillon
<QPapillon@discussions.microsoft.com> wrote:

>Good Day,
>
>I have a column with start dates and I want to have the column beside it
>display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11
>
>How can I do this automatically?
>
>Thanks!
>Carol


It you don't mind 2008-02-29 and 2008-03-01 to result in the same date
"5 years forward", then you can try the following formula

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

Hope this helps / Lars-Åke

Teethlessmama
Sun May 11 16:00:03 CDT 2008

=EDATE(A1,60)

"QPapillon" wrote:

> Good Day,
>
> I have a column with start dates and I want to have the column beside it
> display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11
>
> How can I do this automatically?
>
> Thanks!
> Carol

QPapillon
Mon May 12 16:11:02 CDT 2008

Thank you! -C.

"Lars-Ã?ke Aspelin" wrote:

> On Sun, 11 May 2008 11:04:01 -0700, QPapillon
> <QPapillon@discussions.microsoft.com> wrote:
>
> >Good Day,
> >
> >I have a column with start dates and I want to have the column beside it
> >display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11
> >
> >How can I do this automatically?
> >
> >Thanks!
> >Carol
>
>
> It you don't mind 2008-02-29 and 2008-03-01 to result in the same date
> "5 years forward", then you can try the following formula
>
> =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
>
> Hope this helps / Lars-Ã?ke
>
>
>

QPapillon
Mon May 12 16:13:01 CDT 2008

Thanks! -C.

"Teethless mama" wrote:

> =EDATE(A1,60)
>
> "QPapillon" wrote:
>
> > Good Day,
> >
> > I have a column with start dates and I want to have the column beside it
> > display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11
> >
> > How can I do this automatically?
> >
> > Thanks!
> > Carol