Age calculation

C

Clash

Hi, all.

This one has been bugging me for the last two hours.

I am trying to calculate someones age from their DOB, this I have done
using this formula; =year(today()-A1)-1900, which was kindly given to
me here.

But my boss has just thrown me a curve ball, and asked if I can show
years & months. All I can come up with is years and percentage of year,
I did this by custom formatting. But instead of, say 4 months, it shows
25 months.

Any help would be great.:confused:
 
A

Ardus Petus

My original formula goes false in some cases.
You shoul use

=DATEDIF(A1,TODAY(),"y") to get the number of years
=DATEDIF(A1,TODAY(),'"ym") to get the extra months

HTH
 
Top