2000: AGE calculation & EDATE
Posted by Mark on July 26, 2001 1:36 PM
I have a two conceptually simple questions:
1. How do I calculate an age? I have a cell for current date [=NOW()], and another cell for someone's Date of Birth? Ex: Cell a1: July 26, 2001, cell a2: Date of Birth: 5/1/70....How old is this person?
2. I am running Excel 2000 and this version appears to have done away with some simple formulas like "EDATE". Any suggestions for another formula that will perform the same function?