Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-01-2011, 10:50 AM
Catalin.B Catalin.B is offline How to count year lapse (rounded off) based on specific date Windows Vista How to count year lapse (rounded off) based on specific date Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

to calculate the difference between two dates, in years, use:
=DATEDIF(B6;NOW();"y")
Notice that now() is the computer date, and in B6 is the date value entered.
"y" can be replaced with "m", or "d", or "md", depending on your needs.
Have you ever tried to study an well made excel function dictionary , with most of the functions explained?
I recomend you http://www.xlfdic.com/
For sorting data, you better organize data in a named table, you can do lots of things with your data; a formula cannot sort data in a table.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count year lapse (rounded off) based on specific date Auto insert year only fithawk Word 11 12-21-2016 02:50 AM
Creative Ways for a year-to-year comparison??? ridonkulous5 Excel 1 03-23-2011 04:49 PM
How to count year lapse (rounded off) based on specific date Date auto-populates based on checkbox mcarter9000 Word VBA 5 12-23-2010 12:39 PM
How to count year lapse (rounded off) based on specific date Year janak Excel 6 12-12-2010 10:08 PM
Rounded number breskva Word 0 06-13-2010 10:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 AM.


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