Hello all. I have a data table query and a column specifying “weekend” or “weekday” but I also need “holiday”. This would be based on an Excel list of holidays. What is the best way to update my column to show “holiday” when the date in the holiday table matches the date in the date table?
Or…is there a better solution overall?
Many thanks! Glenn