Excel 2007 : Datedif

=DATEDIF(I3,DATE(YEAR(TODAY()+184)-1,7,1),"Y")


The above formula returns a person’s age (last birthday):
• As at 1 July, last.
• Each year.
• Cyclically.


How do I modify the formula, to:
• Ignore the “1 July” argument before age 60, but still show the person’s age.
• Invoke the “1 July” argument, at and above age 60.

The data input cell, is I3
Cheers,
Mick2

Hello Mick, try this

=DATEDIF(I3,IF(DATEDIF(I3,TODAY(),"y")>=60,DATE(YEAR(TODAY()+184)-1,7,1),TODAY()),"Y")