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.


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=524730