Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-12-2012, 06:45 AM
caz46 caz46 is offline Help with DATEDIF Formula Windows 7 32bit Help with DATEDIF Formula Office 2007
Advanced Beginner
Help with DATEDIF Formula
 
Join Date: Feb 2011
Posts: 73
caz46 is on a distinguished road
Default

Hi,

I am using this formula and it is coming out to be 3 which is correct. We are now for example in January and as we do not count any months that have started I want to calculate the remaining months from the February to the end date on the sheet.

Example we are in January so the equation would return the following results

01-Jan-12 29-Mar-12 2
01-Jan-12 29-April-12 3
01-Jan-12 29-June-12 5

Hope this is clearer.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
help with a look up or if formula beb1227 Excel 3 12-31-2011 01:08 PM
Help with DATEDIF Formula help with formula? doczilla Excel 2 09-25-2011 04:14 PM
Help with DATEDIF Formula Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Help with DATEDIF Formula If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM

Other Forums: Access Forums

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