Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-26-2011, 04:38 AM
meninio's Avatar
meninio meninio is offline help with formulate refers to values Windows XP help with formulate refers to values Office 2010 32bit
Novice
help with formulate refers to values
 
Join Date: Jan 2011
Location: Brasil
Posts: 15
meninio is on a distinguished road
Default help with formulate refers to values

Guys, Good day.



I have a question regarding a formulate. I need to know how many months are left in a contract, for example:
I have the start date (1/11/2011) and termination of a contract (31/12/2011) and based on what we are (26/01/2011) want to know how many months left to end the contract.

I figured it would be like = SUM (contract expires) - (date (today)) or = MONTH (Today) - CONTRACT TERMINATION

Could someone explain to me how it works?

Thanks
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with formulate refers to values Formulate month in Excel 2010 meninio Excel 4 01-25-2011 12:13 PM
Drag Button which refers to the active Word document to Explorer DRob Word 0 10-03-2010 06:40 AM
help with formulate refers to values Using Conditions to Add Values EclipticalD Excel 1 07-08-2010 09:50 PM
Opening .pst with dummy values ran_sushmi Outlook 0 08-19-2009 01:56 AM
Fields controlled by List box values farfromapro Word 0 02-11-2009 02:19 PM

Other Forums: Access Forums

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