Help!!!

[lekmx]

I need a formula that count how many Decembers in a range:

eg.:

start 08/18/2010
end 05/07/2015
= 5

start 08/18/2010
end 11/12/2010
= 0


start 08/18/2010
end 09/18/2015
= 5

Thanks

 

[Joe4]

Does it have to be a complete month (all 31 days), or should it include partial months?

For example, what if you had:
start 01/01/2015
end 12/11/2017
What answer would you be expecting?

 

[lekmx]

Good question buddy, so if you have any day of December the fórmula must count.

Eg.:

Start 11/10/2010
End 12/01/2010
= 1

Start 12/10/2010
End 01/02/2011
= 1

Thanks

 

[Joe4]

If start date is in cell A1, and end date is in cell B1, try this:

=YEAR(B1)-YEAR(A1)+IF(MONTH(B1)=12,1,0)

 

[lekmx]

It is awesome thank you!

 

[Joe4]

You are welcome.