Guys, Good Afternoon.

I have start date 01/30/2009 (A2) and end date 29/01/2011 (B2). That totals 24 months. When I use the formulate month = month (B2-A2) appears 12. Someone could tell me why this?

Sorry for the mistakes, I am Brazilian and it's hard to get help at the forums of my country.



Thanks

In your formula, you appear to be trying to subtract one date from another to get the number of days difference, then asking for the number of months those days would total.

The first part is okay, since your result of B2-A2 comes to 729 days. The problem is with your use of the MONTH function. The MONTH function will give you a month (as a number 1-12) if you give it a date. However, you are asking Excel to tell you what month is "729". Excel is converting the number 729 to a date, in this case it is 29 Dec 1901. The MONTH function then correctly provides you with the number 12 to represent December.

It might be better for you to use the DATEDIF function instead.

For your example, you might try this:

Cheers,

Sorry for my ignorance, but my knowledge is limited! How that would be the formulate?

Have a look.

Attached Files

Using DATEDIF.xls (13.5 KB, 45 views)

Now it worked, thanks for the help.