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.

from the excel help file When you change the default date format to a different format by using this procedure, the display of dates that were previously entered in your workbook will change to the ...

With Excel's Copilot, tasks like classifying feedback or creating summaries can be done quickly by simply typing a prompt ...

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

Expand the drop-down menu and select Use a formula to determine which cells to format. Enter the formula or value (=TODAY () or =TODAY ()+7). Choose the formatting you want to apply.