#1
|
|||
|
|||
Determine age by using birthdate
How can quickly and easily I determine a person's age by using their birthdate?
|
#2
|
|||
|
|||
Assuming cell A1 contains their birthdate then try:
Code:
=TRUNC((NOW()-A1)/365.25,0) now() will return the serial number for the present time. you subtract their birthday from "now" that will give you a number divide that number by 365.25 (since every 4th year is a leapyear) use TRUNC to just return the year (since people don't round up their age - after 21 ) that should do it. Regards, Andrew |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to determine a user's mailbox size limit? | enviroko | Outlook | 3 | 05-13-2010 07:02 AM |
Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |