# Help with Calculating Dates

S

#### scwilson

I am creating a training matrix where I have the date of training an
then I have a drop down box for re-cert identifying when the trainin
expires (i.e. 1 year, 2 year, 5 year). I am hoping to find a way t
automatically populate the re-certification date based on the date o
the training and the drop down selection chosen,

i.e.
Date of training : December 6, 2012

Selection: 2 years

Can I have it automatically calculate that re-certification is Decembe
6, 2015 without having to change the formula each time?

Many thanks!!!!

R

#### Ron Rosenfeld

I am creating a training matrix where I have the date of training and
then I have a drop down box for re-cert identifying when the training
expires (i.e. 1 year, 2 year, 5 year). I am hoping to find a way to
automatically populate the re-certification date based on the date of
the training and the drop down selection chosen,

i.e.
Date of training : December 6, 2012

Selection: 2 years

Can I have it automatically calculate that re-certification is December
6, 2015 without having to change the formula each time?

Many thanks!!!!

S

I'm not sure how you get 2015 if the date of training is 2012 and you add 2 years.
Assuming that is a typo:

Date of training: A1
Selection: B1

Recertification: =edate(A1,b1*12)