| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date-Years-Age of person
I insterted a formula that calculated (Or should have done) for students ages
ata a certain date I.e need to know if students would be 19 on the 31/8/07 I used =year(31/8/2007)-year(6/9//1988) cell references. The answer came back 19 years old but of course student would only be 18 on the 31/8/07. I assume it counts the whole year but need to determine exact age Thanks Steve King |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date to years | Excel Discussion (Misc queries) | |||
| How do I subtract a date from a date for a sum of total years? | Excel Discussion (Misc queries) | |||
| Calculating Age of person on admission date | Excel Discussion (Misc queries) | |||
| Trying to get the next date exactly 5 years ago.. | Excel Worksheet Functions | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
Threaded Mode
