Formula Needed for Dates

[bri_nin]

I have 2 dates, Reported Date & Paid Date. I need to find out if they are in the same month, the following month, etc. So in the next column, I need the output to be a Zero if paid in the same month, 1 if paid in the next month, 2 if paid 2 months later, 3 if paid 3 months later, etc. I have it figured out to give me a zero if paid in the same month by using this: =IF(MONTH(E2)&YEAR(E2)=MONTH(F2)&YEAR(F2),0,"NO") E2 being the Reported Date & F2 being the Paid Date, but I cannot figure out how to get it if it's not the same month. Please help!

THANKS IN ADVANCE!

 

[Joe4]

Welcome to the Board!

Try this (assuming column F is the later of the two dates):

=MONTH(F2)-MONTH(E2)+(YEAR(F2)-YEAR(E2))*12

 

[bri_nin]

Thanks! That is way more simple than what I had written up! (LOTS of IF statements within another IF statement!) Looks like it worked on my sample sets. Thank you so much!

This may be my new favorite site!

 

[SpillerBD]

I was going to suggest with an error check:
=IFERROR((YEAR(F2)*12+MONTH(F2))-(YEAR(E2)*12+MONTH(E2)),)