Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 04-18-2012, 04:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Calculation Windows 7 64bit Date Calculation Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Caholmes

your formula does not take the day into account but only months, therefore creating a result which might not be what the OP needs. Test it for March 31st and you will see that it returns 1 month, although it's less than one month. ( 19 days today)

If one is only concerned about the number of months
Code:
=DATEDIF(A1,today(),"m")
gives the number of entire months between two dates

But then again, as is common with dates, the OP did not specify what he wants exactly
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
calculation of start date ketanco Project 1 02-29-2012 07:01 AM
Date Calculation Formula calculation danbl Excel 8 02-23-2012 04:35 AM
Date Calculation Calculation within Cells manich1 Excel 2 12-07-2011 02:59 PM
Date Calculation Excel Calculation Problem UnholySmoke Excel 2 09-14-2011 08:15 AM
Date Calculation Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 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