If Date Formula

[AlexKimball81]

Hi,
I am trying to find a formula that if the date in cell A4 is within a year of the date in cell f1, it will do one formula, if it is between 1 and 2 years it will do another. Any input will be greatly appreciated.

 

[tyija1995]

Hey, try this formula:
=IF(ABS(F1-A4)<=365,"Formula1","Formula2")
Where Formula1 and Formula2 are replaced by your designated formulae.

 

[Joe4]

=IF(ABS(F1-A4)<=365,"Formula1","Formula2")

Just note that will do Formula2 for any date greater than one year. If they truly want Formula2 only if it is between 1 and 2 years, you will need to nest another level of IF in there.

if it is between 1 and 2 years it will do another.

Something like:

[COLOR=#333333]=IF(ABS(F1-A4)<=365,"Formula1",IF(ABS(F1-A4)<=730,"Formula2",""))[/COLOR]

 

[tyija1995]

You're right Joe, I only omitted nesting the function as there was no criteria in the original posting about a 3rd scenario, but of course then like you say, nesting another layer would be required!
I appreciate the pointer though.