| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating age of individual
How can I display the name of an individual in a given cell. In cell A1 I have today's date; =today(). In cell A2 I have individual's date of birth; 2/1/60 for example. I cell A3 I want to display the individual's age - in this example it would be 06/16/06 minus 02/01/1960. should display 46 years old. Thanks for any comments. -- maacmaac ------------------------------------------------------------------------ maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=553218 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating by individual months of the year | Excel Discussion (Misc queries) | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Threaded Mode
