It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

When you add a date, it uses a predefined format. Even though you need a format like 02/08/2021, Excel Online and Google Sheets may use something else, like 08-02-2021.

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.