Difference in two dates (in years)

[Clay]

When I use the formula to determine a person's age
(determining the diiference between two dates in years),
why does excel round up -basically it only looks at the
year and not the month or day???

Thanks,
Clay

 

[Chip Pearson]

Clay,

What formula are you using? You might want to use the DATEDIF function. See
www.cpearson.com/excel/datedif.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Ron de Bruin]

but is documented only in the help files for Excel 2000

If you not use 2000 you can see it online

http://office.microsoft.com/assistance/offhelp/off2000/excel/xlmain9/html/xlfctDATEDIF.htm