Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-14-2013, 02:47 PM
macropod's Avatar
macropod macropod is offline Converting serial number to years, months and days Windows 7 64bit Converting serial number to years, months and days Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The solution Catalin posted works with the problem you described in your first post (nothing more than a count of days), within the limitations I indicated in my first post.

Your second post relates to an entirely different scenario. You can't expect to get the 'right' answer if you don't provide all the relevant detail. As for DATEDIF, your assertion that it "does nothing different or new compared to simple substraction of the cells" shows you really haven't taken the time to learn how in works - it does far more than a simple addition/subtraction can do. See: http://www.cpearson.com/excel/datedif.aspx

Given the additional information you've now provided, which shows that you're actually trying to calculate an age based on the difference between two dates (in A1 & B1), try:
=DATEDIF(A1,B1,"Y")&" years, "&DATEDIF(A1,B1,"YM")&" months & "&DATEDIF(A1,B1,"MD")&" days"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



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 06:06 AM.


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