Compare Dates in a Cell Range If Greater Than, Less Than or Equal To Another Date

Question

I have expected ending dates in Column I through L (I3:L3)

I have the actual ending date in Column M (M3)

What I would like to do is have formulas to compare the date range values in (I3:L3) to the actual ending date value in (M3) to see:

1. If the actual ending date is greater than the date range
2. If the actual ending date, is less than the date range
3. If the actual ending date is equal to the date range

Thank you for the help.

Answer 1

Hi Carol

Please, try formulas

Greater =IF(M3>MAX(I3:L3),"Yes","No")

Less         =IF(M3<MAX(I3:L3),"Yes","No")

Equal =IF(ISNUMBER(MATCH(M3,I3:L3,0)),"Yes","No")

Do let me know if you need more help

On the other hand,

If the answer helped you.

Please, consider marking this thread as answered.

It would help others in the community with similar questions or problems.

Thank you in advance

Regards

Jeovany