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!!!!
 
Ad

Advertisements

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top