insert holidays to weekday

eshai 1 Reputation point

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


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

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,649 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
{count} votes