Question: Returning a specific text based on the date

Hello,

Brand new user with what I'm hoping is a stupid question. I've been going to through the forum here and I can't seem to find anything that has a reference to what I'm looking for.

I am trying to write a formula to return the word "Holiday" in cell A10 if cell A9 shows a date that matches a list of holidays referenced on another tab (='Reference Sheet'!F1:F20). The trick is that I want cell A10 to show the day of the week if A9 is not a holiday.

The dates are referenced from the date listed on the reference sheet and continued with the formula =Workday(A9,1).
The days of the week are referenced to the date above and displayed using =Text(A9,"dddd"). This is the cell that needs to change and I've tried every formula I can think of.

Any thoughts?

Thank you Ali,

Please see attached

put this into L3

=IF(IFERROR(MATCH(L2,Sheet2!$F$1:$F$20,0),0)>0,"Holiday",TEXT(L2,"dddd"))

Or try this formula in A3:

=IF(COUNTIF(Sheet2!$F$1:$F$20,Sheet1!A2),"Holiday",TEXT(A2,"dddd"))

Thanks Phuocam, that worked great!

You are welcome!