# Adding Years to a Date

This topic is 6607 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

This is a very simple problem... I just do not know how to do it.

How do you add years (in a number format) to a date (Date Format)

Example:

21 (Years) + 2-14-05 = 2-14-26

Help

Joseph

##### Share on other sites

Assuming you have two fields already (i.e. a date field and a number field), substitute your field names for "AnyDate" and "Number_of_Years"

Your Calculation Field would look like this:

c_FutureAnyDate (calc, Date Result) =

Date(Month(AnyDate), Day(AnyDate),Year( AnyDate)+Number of Years)

HTH

Lee

##### Share on other sites

I am not sure I understand this equation....

Can you help me alittle more?

##### Share on other sites

AnyDate is your date field or hard-coded date. Applying it to your example would look like

Date( 2; 14; 2005 + 21 )

or

Date( Month(Date( 2; 14; 2005 )); Day((Date( 2; 14; 2005)); Year(Date( 2; 14; 2005)) + 21 )

or

Date( Month(AnyDate); Day(AnyDate); Year(AnyDate) + YearsToAdd )

as in Lee's calculation.

##### Share on other sites

Cool thanks

That helped me... thank you to both of you.

Joseph

##### Share on other sites

This topic is 6607 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account