Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Calculating Dates
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with Calculating Dates
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating dates | Excel Discussion (Misc queries) | |||
calculating dates to now() | Excel Worksheet Functions | |||
Calculating dates | Excel Worksheet Functions | |||
Calculating Dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |