View Single Post
  #1   Report Post  
revkermit
 
Posts: n/a
Default 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!