Number of last days of the month between 2 dates

[JoshLyman]

I'm sure this is very easy to achieve, but my brain is failing me. Essentially I need to calculate the number of times the last day of the month has been reached between 2 dates. I've tried using DATEDIF but it's not working as I expected and is giving me different results if the day of the month for the second date is before the day of the month of the first;

e.g.,

In the above example, I want it always say 12. Unless date 2 is that last day of the month, in which case I want it to say 13.

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	K	L	M
1
2	15/01/2023	02/01/2024	12
3	08/01/2023	31/01/2024	13
4	15/01/2023	09/01/2024	12
Main

Cell Formulas
Range	Formula
M2:M4	M2	=DATEDIF(K2,EOMONTH(L2,0),"m")+(L2=EOMONTH(L2,0))

 

[JoshLyman]

Thanks Fluff! That works a treat.

 

[Fluff]

You're welcome & thanks for the feedback.