dynamic calculation of months remaining given end date and today

C

Cruz_Control

I am trying to calculate the Value of set of contracts and I need a field to
dynamicly calculate the number of months remaining in a contract given the
end date from today in another column. Thanks for the help.
 
P

Pete_UK

Assume your end date is in A1 in Excel date format. This will give you
the number of months remaining, taking 30 days to be a month:

=IF(A1<=TODAY(),"Passed",(A1-TODAY())/30)

Format the cell as Number with 1 or 2 dp.

Hope this helps.

Pete
 
J

JMay

=DATEDIF(TODAY(),B5,"m") << will give you the Full Months difference
where B5 contains the projected End-date.
 
Top