Adding 5 yrs to a date

's Computer Specifications

How can I add 5 yrs to an existing date using a formula?

Current Date Desired Date
09/25/2007 09/25/2012

Thanks for your time....

's Computer Specifications

One way:

A1: Current Date
B1: =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))

In article <8BB91860-D258-4DFC-99BF-(E-Mail Removed)>,
mazalam <(E-Mail Removed)> wrote:

> How can I add 5 yrs to an existing date using a formula?
>
> Current Date Desired Date
> 09/25/2007 09/25/2012
>
>
> Thanks for your time....

's Computer Specifications

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"mazalam" <(E-Mail Removed)> wrote in message
news:8BB91860-D258-4DFC-99BF-(E-Mail Removed)...
> How can I add 5 yrs to an existing date using a formula?
>
> Current Date Desired Date
> 09/25/2007 09/25/2012
>
>
> Thanks for your time....

's Computer Specifications

=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
--
David Biddulph

"mazalam" <(E-Mail Removed)> wrote in message
news:8BB91860-D258-4DFC-99BF-(E-Mail Removed)...
> How can I add 5 yrs to an existing date using a formula?
>
> Current Date Desired Date
> 09/25/2007 09/25/2012
>
>
> Thanks for your time....

's Computer Specifications

With
A1: (current date)

This formula won't get tripped up by a 29-Feb (leap year) start date:
=MIN(DATE(YEAR(A1)+5,MONTH(A1)+{0,1},DAY(A1)*{1,0}))

If today is 29-Feb-2000,
the formula returns: 28-Feb-2005
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"mazalam" <(E-Mail Removed)> wrote in message
news:8BB91860-D258-4DFC-99BF-(E-Mail Removed)...
> How can I add 5 yrs to an existing date using a formula?
>
> Current Date Desired Date
> 09/25/2007 09/25/2012
>
>
> Thanks for your time....

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Ver 2.0 Adding days to a date to give target date excluding weekends?	michael.nilsen@sgs.com	Microsoft Access Macros	1	30th Nov 2006 02:20 AM
Access Ver 2.0 Adding days to a date to give target date excluding weekends?	Michael	Microsoft Access Forms	2	19th Nov 2006 10:52 PM
Access Ver 2.0 Adding days to a date to give target date excluding weekends?	michael.nilsen@sgs.com	Microsoft Access VBA Modules	1	19th Nov 2006 01:06 PM
Changing the date format & adding the date range to the header	=?Utf-8?B?UHVyZUV2aWw=?=	Microsoft Access	1	6th Oct 2006 11:31 PM
Reports---adding Month-To-Date and Year-To-Date totals	Patricia R. Turner	Microsoft Access Reports	1	19th Sep 2003 06:23 PM