Seeing if a bank holiday date falls within current month's date range

[FORDFAN]

Hi.

Need help.

In one column, I have the dates of a month, e.g. April 1st to April 30th in column A.

I have a range called "holidays" that are all the bank holidays for this year in column B.

I know Easter falls within April so what I am after is a formula that will look for any matching dates between column A and column B.

My plan is to have it recognise a bank holiday day and not calculate a formula in that date.

Can anyone help?

 

[steve the fish]

Its a bit vague what you require but maybe this?

=IF(ISNUMBER(MATCH(A1,holidays,0)),"Holiday","Not holiday")