| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to calculate someone's exact age
I tried using (for example) "=YEAR(D6)-YEAR(E6)" to determine someone's exact
age based on their birthdate and today's date (formatted military-style as dd-mmm-yy). In the example below, the above formula produces an incorrect answer because it seems to round up. Subtracting the following two dates YEAR(28-Aug-07)-YEAR(17-Sep-83) produces the number "24", which is correct when you go by the year "yy", but actually incorrect because this person isn't actually 24 years old until 17-Sep-07. Why does EXCEL seem to round up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
| Formula to compute someone's age if you enter their B-day | Excel Discussion (Misc queries) | |||
| EXACT formula | Excel Discussion (Misc queries) | |||
Threaded Mode
