Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2013, 02:10 PM
hannu hannu is offline Converting serial number to years, months and days Windows 7 Converting serial number to years, months and days Office 2007
Advanced Beginner
Converting serial number to years, months and days
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default


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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting serial number to years, months and days How do I get auto-updated "number of days since specified date" on MS word? terry795 Word 16 01-07-2016 04:33 PM
Converting serial number to years, months and days Increase serial number for every print atomtm Word 1 06-15-2012 05:39 AM
Converting serial number to years, months and days 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft