Calculating Number of Months Between Dates in Different Years

[TommyDoes]

=(YEAR(B4)-YEAR(B3))*12+MONTH(B4)-MONTH(B3)

B3--31/11/2013
[TABLE="width: 279"]
<tbody>[TR]
[TD="class: xl64, width: 279"]B4--31/03/2014

format dd/mm/yyyy

I continually get a return of #VALUE.

Please help,
Tom[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Why not just use the DATEDIF function?
MS Excel: How to use the DATEDIF Function (WS)

 

[MARZIOTULLIO]

HI


November 30 days

 

[Jonmo1]

November 30 days

Good Catch.

I must admit, at first I thought "what the heck does that have to do with anything", lol.

 

[Joe4]

B3--31/11/2013

As Mariziotullio pointed out, November only has 30 days, not 31.
You shouldn't even be able to enter a date like that -- unless you really aren't entering dates at all, but rather strings.