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

  2. On Tue, 10 Dec 2013 12:37:19 +0000, scwilson <> wrote:

    >
    >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)
     
    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.