Thread: [Solved] help with formulate refers to values
View Single Post
 
Old 01-26-2011, 04:38 AM
meninio's Avatar
meninio meninio is offline Windows XP Office 2010 32bit
Novice
  
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