Share via

insert holidays to weekday

eshai 1 Reputation point
2022-04-03T17:06:50.35+00:00

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

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,720 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,689 questions