count number of months

I need to create a formula that will count numbe rof months..Basically if you took this month ..then how many months back is the month in a certain cell..

What I came up with does that, but the only problem is its using a 30 day count..so that December shows up as both 1 and 2 months back..

Here is the formula I currently have: =MONTH(TODAY()-F189)

Notice how even though all of them are December some are counting as 1 month back and other are counted as 2 months back.. I tried using other functions like "now" but this is the closes I got to what I want... Would appreciate any help anyone can give me on this. Thanks.

date months back from current month
12/26/2013 2
12/26/2013 2
12/27/2013 2
12/30/2013 1
12/30/2013 1
12/30/2013 1
12/30/2013 1
12/31/2013 1
12/31/2013 1
12/31/2013 1
12/31/2013 1
12/31/2013 1
12/31/2013 1
12/31/2013 1

That is the formula that I used. So not quite understanding your question. When I use that formula..I get the results I posted in the post.. For December I get 1, until the date is beyond 30 days then it becomes 2... I need it to just look at the month, not count by days.. so if you were to take this month... then December 2013 would be 1 month back, November 2013 would be 2 months back etc.

Sorry I take that back I didn't notice the "-month" in your formula.. However when I use the formula You suggested I get a "1" for every month. So that did not work either...Thank you.

Originally Posted by bebo021999

Maybe DATEDIF can do this:
=DATEDIF(F189,TODAY(),"m")

Sorry ..that gives the same result as the original formula..

OK I attached a sample worksheet..

Ok The formula you just posted is doing the same as my original formula.. basically it is counting 30 days..so it looking at todays date and counting back 30 days as 1 month.. so when you get to Dec 27th it see that as more than 30 days so now that is another month.. etc.. What I need it to do is look at all Dec as 1, all Nov as 2, all Oct as 3 etc.. so when I put in new dates in February it wil then look at all Jan 2014 as 1, Dec 2013 as 2, Nov 2013 as 3, and so on.. I want the formula to make all the changes and conversion. In other words when i copy in new dates into th date fields and the current month has changed, the formula takes in account that the month has changed..that is why I was using "today" function. I don't want to have to go into the formula every month and change something it it.

Bingo...chicken Dinner we have a winner.. Thanks Bebo for your tenacity...

Originally Posted by bebo021999

Nice to hear that.
Anyway, this way of month calculation seems so strange to me ...

Basically what it comes down to is I am trying to find out what is older than 3 months, and what is 3 months or less from tthe current month.