How do I automatically calculate ages in Xcel?
 

I have part of the formula figured out (i THINK) but I'm running into a brink
wall. I figured this would be a popular formula, but apparently it's not.
The YEAR funtion doesn't work because it apparently only bases it's output on
the date's YEAR...so it doens't understand if the person's birthday hasn't
come around yet.

HELP PLEASE!

Try

http://www.cpearson.com/excel/datedif.htm

Regards,

Peo Sjoblom


"revkermit" wrote:

I have part of the formula figured out (i THINK) but I'm running into a brink
wall. I figured this would be a popular formula, but apparently it's not.
The YEAR funtion doesn't work because it apparently only bases it's output on
the date's YEAR...so it doens't understand if the person's birthday hasn't
come around yet.

HELP PLEASE!