This formula will calculate a person's age in excel (assuming date of birth is in cell A1)
=IF(MONTH(TODAY())>MONTH(A1),YEAR(TODAY())-YEAR(A1),
IF(AND(MONTH(TODAY())=MONTH(A1),DAY(TODAY())>=DAY(A1)),
YEAR(TODAY())-YEAR(A1),(YEAR(TODAY())-YEAR(A1))-1))
Showing posts with label Calculate Age. Show all posts
Showing posts with label Calculate Age. Show all posts
Wednesday, March 9, 2011
Subscribe to:
Posts (Atom)