=TEXT(B1, "dddd") In the above formula, B1 is the cell’s address containing the date. Your Excel sheet may have a different address. The next step is to format the date only in the DD format.

By default, Excel names sheets using the Sheetx format where x is a consecutive number, as shown in Figure A. Figure A. You can rename Excel sheets. As you add more sheets, x increases accordingly.

In Excel 2003, choose Conditional Formatting from the Format menu, and skip to step 4. In the top pane, select the Format Only Cells That Contain option. From the second dropdown, choose Equal To.

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.

How to Format Relative References in Excel. ... For example, "=Sheet2!A1:B5" references a range of 10 cells on "Sheet2." Sheet names are located on tabs near the bottom of the Excel window.