The WEEKDAY() function returns TRUE for weekend dates in Excel. Now that we know what function we’ll use to set a conditional format, let’s do so. How to apply the rule online in Excel ...

Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December.

Excel's Format Chart Pane, with the first drop-down menu expanded and highlighted. The legend in an Excel chart is selected, and the Format Legend options are displayed in the Format Chart Pane.

Even though you need a format like 02/08/2021, Excel Online and Google Sheets may use something else, like 08-02-2021. At times, you might not like such a change due to a lack of familiarity.

The article, Use a custom format in Excel to display easier to read millions uses a custom format to make large values more readable. For instance, 1,200,000 displays as 1.2 M instead—the format ...