Help with Calculating Dates

Discussion in 'Excel Beginners' started by scwilson, Dec 10, 2013.

  1. scwilson

    scwilson Guest

    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,

    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!!!!
    scwilson, Dec 10, 2013
    1. Advertisements

  2. 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)
    Ron Rosenfeld, Dec 13, 2013
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.