| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
projecting when a person is 70 from DOB
i have a huge list of people of all ages and I need to project the exact date
when they are 70 from their Date of Birth but when I add 70*365.25 to the DOB some give the exacct date and some are a day out, Is there a more exact formula I can do as I need the excact date for each person when they turn 70. This is what I got using mu formula DOB When 70 28/04/1954 27/04/2024 28/04/1934 27/04/2004 12/12/1930 11/12/2000 01/02/1955 31/01/2025 24/10/1945 24/10/2015 22/09/1951 21/09/2021 25/12/1907 24/12/1977 12/05/1935 11/05/2005 01/03/1940 01/03/2010 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Person Names Smart Tag problems | Excel Discussion (Misc queries) | |||
| Protection or some other method used to person must "save as" | Excel Discussion (Misc queries) | |||
| Rostering problem | Excel Discussion (Misc queries) | |||
| D Sum or SumIF | Excel Worksheet Functions | |||
| how is possible working on work sheet by two person in the netwo. | Excel Worksheet Functions | |||
Threaded Mode
