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,

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