dynamic calculation of months remaining given end date and today

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation of monthly payments per employee 2
difference in days between two date columns 4
A simple date calculation question. 11
Calculating Months within a specific period 6
Calculate age with an end date 3
Counting calendar Days - not including Sundays 3
Difference between dates returning full months and remaining days 5
Template for calculating different number of days between 2 dates 1

Back
Top