Difference Between Dates in Months with a Maximuim number

[reneev]

So I have to calculate the number of months between two dates. I have that formula (=DATEDIF(F3,$D$1,"m")+1). However, I need to put a caveat in there that says if the number is more than 11, keep it at 11.

This number is being used to average a sum and the number of months to average is either the actual number of months between the two dates or a maximum of 11.

Can anyone help?

 

[Eric W]

Maybe:

=MIN(11, DATEDIF(F3,$D$1,"m")+1)

 

[reneev]

That worked! Thank you!

So, what did that do? What is MIN?

 

[Eric W]

MIN is short for Minimum, and it just finds the minimum value of a set of numbers. So if your DATEDIF formula returns a value of 7, then MIN(11, 7) will return 7. But if your DATEDIF formula returns 13, then MIN(11, 13) will return 11. So that's just a convenient way to set a cap for your values.

I'm glad this worked for you!