Formula for Subtracting Dates to figure out number of months

Hello,

How would you go about doing 03/31/2014 minus today's date in order to get the number of months in between those dates?

Thanks!

We need a clearer definition of how to count months (criteria for a month to be included in the count)

Say you have

3/15/2013 minus 2/27/2013 ???
4/20/2013 minus 2/07/2013 ???

etc..

Basically, 2 questions.
Does it need to be an ENTIRE month for it to be included, or just at least 1 day from a month to be included ?
Are the beginning and/or ending months included in the count?

Sorry, I see what you're saying now.

I need number of days between two dates, but reflected in months.

So for example, between today (12/2/2013) and 03/31/2014, there would be 120 days, which translates into 4 months.

So more specifically, how many 30 day periods...

You could just do
=(A1-TODAY()+1)/30

A1 = 3/31/2014
The +1 is because a simple A-B will not include the begin date (3/31/2014 minus 12/2/2013 = 119, not 120)

Thanks a lot man!

You're welcome.

You could also do =DATEDIF(A1,B1,"M")

Hey I wanted to get your advice again as I am not sure if this is working properly.

I have the following columns:

Balance March 31, 2014 (H4)- Expenses per Month (O4)

So I want to be able to see how many months until funds reach zero from today, based on that projected March 31 2014 balance.

Right now I have it complicated, where I am getting the number of months until zero from March 31, but then adding the months from today until March 31.

This is what I have:

=IF(O4=0,"",((H4/O4)+((YEAR(TODAY())-YEAR($E$117))*12+MONTH(TODAY())-MONTH($E$117))+($E$117-TODAY()+1)/30))

E117 is the March 31, 2014 date.

Am I doing this right?