Remember Me?

#1
December 10th 13, 01:37 PM
 Junior Member First recorded activity by ExcelBanter: Dec 2013 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
December 13th 13, 04:11 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jun 2010 Posts: 1,045
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)

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post future spreadsheet master Excel Discussion (Misc queries) 3 May 13th 09 11:27 PM Todd[_3_] Excel Worksheet Functions 3 October 28th 08 07:36 PM countrygirl0712 Excel Worksheet Functions 3 March 18th 08 06:20 PM Anne Excel Worksheet Functions 6 February 7th 08 01:56 AM [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM

All times are GMT +1. The time now is 07:28 AM.