If # days < xx, then add one year

[Roar]

Hi all, I know how to add one year to a date with this function

=DATE(YEAR(C5)+1,MONTH(C5),DAY(C5))

How can I expand this to say if Cell E5 is less than 61 (days), then add one year.

Thank you, I appreciate the help

 

[JoeMo]

Assuming you want the formula to return C5 if E5 is 61 or greater:

=IF(E5<61,DATE(YEAR(C5)+1,MONTH(C5),DAY(C5)),C5)

 

[Rick Rothstein]

Assuming you want the formula to return C5 if E5 is 61 or greater:

=IF(E5<61,DATE(YEAR(C5)+1,MONTH(C5),DAY(C5)),C5)

Another way to write that...

=DATE(YEAR(C5)+(E5<61),MONTH(C5),DAY(C5))

 

[Roar]

Oh thank you thank you thank you! I have a project to present to work and now they will think I am über smart.