Microsoft Office Tutorials and References
In Depth Information
Calculating a Person’s Age
If you’re a stickler for accuracy, here’s another version:
=DATEDIF(B1,B2,”y”) & “ years, “&DATEDIF(B1,B2,”ym”) &
“ months, “&DATEDIF(B1,B2,”md”) & “ days”
This function returns a text string, like this:
33 years, 8 months, 17 days
For more information about the elusive DATEDIF function, see Tip 100.
Search JabSto ::

Custom Search