Match a date from a Table of dates, Help Please.

[john dalton]

Hi I have a table of bank holiday dates, I need a formula to indicate whether a date is in the table when a user enters a date.

Please see attached sheet for details.

Thanks in advance

JD

[berlan]

In F2, try:

=IF(OR(ISNUMBER(MATCH($E2,$D$7:$D$14,0)),ISNUMBER(MATCH($E2,$E$7:$E$14,0)),ISNUMBER(MATCH($E2,$F$7:$F$14,0))),"Yes","No")

and copy across to F3.

Hope that helps,
berlan

[john dalton]

Many thanks that works perfectly.

John