Need formula to perform two different date functions

[jwest510]

Hello,

I'm a complete newbie here and am somewhat familiar with excel, yet I have the challenging task (for me) to develop a spreadsheet that will calculate different record retention destruction dates based off of a value in one cell. So, for example, Cell A1 has a retention value of 3 (3 years) A2 has the record creation date of 1/1/2018, A3 should have the destruction date of three years from the creation date. I also need that cell to be able to run a similar calculation if cell A1 has a retention value of 7 (7 years) where cell A3 will now return a destruction date of seven years from the creation date in cell A2. I'm hoping this is a question that won't break a sweat for someone, but for me, I'm drenched. Thanks for your help.

 

[Tetra201]

Try

=EDATE(A2,A1*12)

 

[jwest510]

Thanks for the speedy reply! That works pretty darn good. Now would you know how I could get cell A3 to perform two different date calculations? If I put a 3 in cell A1 I want cell A3 to calculate 3 years in the future. If I put a 7 in cell A1 I want A3 to calculate 7 years in the future. Is that even possible?

 

[jwest510]

AH HA!!! D'OH!!! Thank you so very much.

 

[Tetra201]

A1 ... 3
a2 ... 1/1/2018
a3 ... =edate(a2,a1*12) ==> 1/1/2021

a1 ... 7
a2 ... 1/1/2018
a3 ... =edate(a2,a1*12) ==> 1/1/2025

 

[jwest510]

Again... thank you so very much!!!

 

[Tetra201]

You are welcome.