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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jayensmi

    Division formula not calculating/Help

    jayensmi, Jan 24, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    77
    Frank Kabel
    Jan 24, 2004
  2. GreenMan

    Calculating Dates by Month - please help!!!

    GreenMan, Jun 22, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    101
    Trevor
    Jun 22, 2004
  3. X

    Help with calculating by month

    X, Jul 4, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    72
  4. date formats morph the dates/chang case

    the dates on cell format make different dates.

    date formats morph the dates/chang case, Apr 17, 2005, in forum: Excel Beginners
    Replies:
    6
    Views:
    129
    Ragdyer
    Apr 18, 2005
  5. martins

    Calculating Days Between Dates

    martins, Mar 25, 2006, in forum: Excel Beginners
    Replies:
    6
    Views:
    95
  6. hoyt
    Replies:
    5
    Views:
    207
  7. spudpeeps

    CALCULATING DATES

    spudpeeps, Dec 5, 2007, in forum: Excel Beginners
    Replies:
    3
    Views:
    97
    WLMPilot
    Dec 6, 2007
  8. spudpeeps

    calculating dates

    spudpeeps, Dec 5, 2007, in forum: Excel Beginners
    Replies:
    2
    Views:
    72
    Luke M
    Dec 5, 2007
Loading...