dynamic calculation of months remaining given end date and today
 

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.
--
Cruz_Control

dynamic calculation of months remaining given end date and today
 

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

On Apr 30, 3:48 pm, Cruz_Control
wrote:
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.
--
Cruz_Control

dynamic calculation of months remaining given end date and today
 

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


"Cruz_Control" wrote:

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.
--
Cruz_Control