Excel Forum
Similar Content
Add Time Together Limiting by Working Hours and Excluding Weekends and Holidays in Excel
Tutorial: Add two times together to get a future date and time that falls within working hours, excl...
8 Tips to Become an Expert in Conditional Formatting for Excel
Tutorial: Become a master of Conditional Formatting in Excel! This tutorial covers 8 tips and trick...
Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager
Tutorial: Excel quickie tutorial that will show you a great tip for working with formulas within th...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays


See how to use the OR and WEEKDAY functions to create a logical true / false formula that will apply formatting to a date when it is the weekend or a holiday.





Got a Question? Ask it Here in the Forum.