calculating number of months in excel

Hi i am working on a spreadsheet that should calculate the number of months remaining on a lease, or the number of months that have passed this is the information i have available

and what would be entered into the sheet
example?
LEASE A
start date 12/26/2009
Term : 44 months

I would like something that will tell me the number of months remaining on this lease , according to my calculations there should be 30 months remaining . what is the easist way to do this and just drag down the formula

further more, if the lease is expired or has less than 6 months left i would like it to return "expired"

Any help would be appreciated~ thanks

Try this......Change the Lease Date

Only problem is that the month is assumed to be 30 days....not sure how to get around this problem :/

Hi, a possibility in A1 start date

=44-DATEDIF(A1,TODAY(),"M")

Hope that helps

Regards

Give the attached a try

Just found these replies very useful. As it is coming to year end we need to calculate the Number of months between our YEAREND Date and the End of Lease date. I managed to tweak the solutions suggested here.
Thanks Guys I think your dedication to this forum is great! Isabelle

Thank you! These formulas have been useful for my work!