Using specific date and time formats, you can display a date or time in many ways. That’s not how Excel stores a date, though—not as the formatted string that you see.

Create a custom date format based on one of Excel's standard date templates. For example, set all months to display as two digits by adding another "M" to the month format code. Advertisement ...

Now, it’s time to apply the conditional format rule that will highlight all weekend and holiday dates in your date list in column B: Select B4:B49 (you want to select the list of dates you want ...