|
|
#1
01-26-2011, 04:38 AM
|
||||
|
||||
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  
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 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 |
|
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 |
Windows XP 
Office 2010 32bit
Threaded Mode