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