## Highlight dates that are weekends in Excel

This tutorial shows how to Highlight dates that are weekends in Excel using the example below; Formula =OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1) Explanation If you want to use conditional formatting to highlight dates occur on weekends (i.e. Saturday or Sunday), you can use a simple formula based on the WEEKDAY function. For example, if you have dates in the …