If then, date + 15yrs

[Alphazulu]

I'm trying to put together an formula (if/then?) that will do the following

Formula to be placed in Cell N3
If E3 = "Initial File"
Then return the date in cell L3 + 15 years


Thanks again -

 

[texasalynn]

try this

=IF(E3="Initial File",EDATE(L3,180),"")

 

[VoG]

Try

=IF(E3="Initial File",DATE(YEAR(L3)+15,MONTH(L3),DAY(L3)),"")

 

[Alphazulu]

=IF(E3="Initial File",DATE(YEAR(L3)+15,MONTH(L3),DAY(L3)),"")

This worked perfectly! Can it do the same thing for multiple selections? For example, if Initial File or Original File, Final File, Old File, Missing File is in Cell E3 return L3+15yrs.

Or could I point the formula at a list of options that should return the L3 date + 15yrs result?

 

[VoG]

Try

=IF(OR(E3={"Initial File","Original File","Final File","Old File","Missing File"}),DATE(YEAR(L3)+15,MONTH(L3),DAY(L3)),"")

 

[Alphazulu]

The exciting part is that I can see this working and am getting closer to making my life a lot easier thanks to your help.

Unfortunately, I keep finding new questions with every small win.

Now I need leave the cell blank if none of the matches (Initial File","Original File","Final File","Old File","Missing File) are found.

Thank you very much for all of your help

 

[VoG]

Now I need leave the cell blank if none of the matches (Initial File","Original File","Final File","Old File","Missing File) are found.

Um - it does. Try entering "New File" in E3 - the date in N3 should disappear.

 

[Alphazulu]

aha.

How about if no date is entered into L3 to return blank. It currently returns 12/31/1914?

 

[VoG]

Try

=IF(L3="","",IF(OR(E3={"Initial File","Original File","Final File","Old File","Missing File"}),DATE(YEAR(L3)+15,MONTH(L3),DAY(L3)),""))

 

[Alphazulu]

That did it!

Thank again and have a good weeken