Formula to count down months remaining?

Hello I'm pretty competent with MS software but when it comes to the equation side of Excel I'm at a loss. My goal here is to create a spreadsheet of many cars and countdown the months remaining on their warranty. I wanted to have my whole car list in one excel file and a column displaying the remaining months (I would be able to enter "30" months or whatever I have no idea) I would go by the 1st of each month remaining I guess just to give an idea around when it would expire. Any help would be greatly appreciated. Thank you!

Jon

Perhaps the DATEDIF() function: http://www.cpearson.com/excel/datedif.aspx

Hey thanks, I'm really oblivious to all this...Okay. Hmm. I tried it and my result is a "#NAME?"

=DATEDIF(1-APRIL-2012,1-JAN-2013,"M") is what I entered. i was hoping for a "9" as the result, showing 9months remaining. Any other suggestions or corrections?

Make sure the 1-APRIL-2012 and 1-JAN-2013 are date values. They look like text as is.
You can have the date values in cells and use the cell references within the formula.

Oh, and when you input the dates directly in the formula (instead of referncing cells that hold them) you have to put the dates within double quotation marks.

So (on my comp) it would be: =DATEDIF("12/4/1","13/1/1","m") which results in 9

Alright I c/p'd yours and it gave me a #VALUE! result, but I changed the date structure to (1/4/12) instead of (12/4/1) and it worked! Thank you so very much for your assistance!

That's why I said (on my comp) - I'm north of the border, eh. Different date formats / metric system / etc
You're welcome.

lol ah-ha! gotcha Thanks much brother of the North!