![]() |
|
#4
|
|||
|
|||
|
Formatting the "age" cell B1 to date does not give the correct answer, if the date of birth is for instance 1 jan 1012, the date today is set to 1 jan 2013 the substarcted value displayed in date format is 31 days, 12 months and 00 years, which is incorrect.
I found a function in the internet called DATEDIF which interestigly is an "undocumented" function but that does nothing different or new compared to simple substraction of the cells containing DOB and TODAY.. both give the number of days between two dates. I found an another Integer formula that works, just seems awfully complicated for a simple calculation, I thought Excel would have something simple to solve that common question. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How do I get auto-updated "number of days since specified date" on MS word?
|
terry795 | Word | 16 | 01-07-2016 04:33 PM |
Increase serial number for every print
|
atomtm | Word | 1 | 06-15-2012 05:39 AM |
Serial Number Issue
|
rehan5001 | Excel | 1 | 06-08-2011 02:46 AM |
| Setting up recurring months to skip some months etc. | dwelch@ykfireprevention.c | Outlook | 0 | 11-30-2010 10:15 AM |
| Help needed using the serial number date with sumifs - whole office is stumped | FraserKitchell | Excel | 3 | 01-06-2010 12:24 PM |