Date less than or equal to is only picking up less than date

Hi guys,

I've got a formula

=IF(AND(A15187>='Welcome Page'!$D$13,A15187<='Welcome Page'!$D$15),"Yes","No")

which looks at two dates (D13 and D15) on the welcome page worksheet and compares it to a date in a list and if the date is in that list range.

However, the upper limit does not display a Yes even if it is within range. However if I extend the range to beyond that date, it picks it up. Basically, the 'equal to' function is not working, its only recognising dates less than.

E.G.

If I set the range 17/6/16 to 18/6/16, I will get only the 17th returned. If I extend it to the 19/6/16, I will now get values from the 18th returned. So its working on every level EXCEPT that it does not pick up values equal to the second, later date.

Any help gratefully received.

Thanks

Bob

Hi Bob,

Could we see some (desensitized) sample data in workbook where this is happening? Nothing wrong with the formula and is should work. May be some underlying issue.

BSB