insert holidays to weekday

i build a Monthly hourly report

A10:A40 is the date =DATE(H6,E6,1) E6=month H6=year

B10:B40 is weekday formatted as"dddd"

i have spreadsheet called holidays A:A= holiday date B:B = holiday name
i want to replace the name of the weekday to the name of the holiday name if the date is holiday
my code for now is

 =IF(ISERROR(VLOOKUP(A10,holidays!A:C,3,0)),TEXT(WEEKDAY(A10),"dddd"),("holiday"))

so im if holidays date fall on the month date it replace the weekday name to "holiday" But I want the name of the holiday
as you can see i included in the code holidays!A:C,3,0 where "C" is the result of A:B and "3" is the value to return
so the code is =`IF(ISERROR(VLOOKUP(A10,holidays!A:C,3,0)),TEXT(WEEKDAY(A10),"dddd")`

i'm not an expert in excel

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft · Apr 04 at 06:29 AM

@eshai-6481
I want to help you, but could you please share us with a simple sample with the results that you want?
You can take a screenshot to show us more details. Such as the data of column C.
Thanks for your understanding.

0 ·

eshai-6481 emilyhua-msft · Apr 04 at 03:01 PM

thank you
No matter I solved it

0 ·

emilyhua-msft eshai-6481 · Apr 05 at 01:24 AM

Hi @eshai-6481,
Thanks for your reply.
Could you please share us your new formulas or the feature that you use in the format of Answer?
This action can help other users on Q&A forum. :)

0 ·

question