View Single Post
 
Old 02-14-2013, 02:10 PM
hannu hannu is offline Windows 7 Office 2007
Advanced Beginner
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default

Formatting the "age" cell B1 to date does not give the correct answer, if the date of birth is for instance 1 jan 1012, the date today is set to 1 jan 2013 the substarcted value displayed in date format is 31 days, 12 months and 00 years, which is incorrect.
I found a function in the internet called DATEDIF which interestigly is an "undocumented" function but that does nothing different or new compared to simple substraction of the cells containing DOB and TODAY.. both give the number of days between two dates.

I found an another Integer formula that works, just seems awfully complicated for a simple calculation, I thought Excel would have something simple to solve that common question.
Reply With Quote