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

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

=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