You presumably mean DATEDIF, not DATEIF ?
I've suggested the use of
http://www.cpearson.com/excel/datedif.aspx which
will also show the syntax to get the days part to add to the number of
years.
--
David Biddulph
"SGT Buckeye" wrote in message
ups.com...
On Nov 14, 5:30 pm, jland wrote:
try this:
=dateif(date1, date2, "Y")