Date Formatting In Excel

Using the Date Format:

You should choose the cells that contain the date(s) you want to format. Navigate to the Excel ribbon's "Home" tab. You can locate the "Number Format" selection in the "Number" group. Toggle it on. Select "Date" from the list of options. Formatting dates specifically:

You can build custom date formats if the default ones don't work for you. For this:

Pick the cells that contain dates. Right-click, then select "Format Cells" (or press Ctrl + 1). Navigate to the "Number" tab in the "Format Cells" dialogue box. Choosing "Date" from the left side.

Know more :https://www.youtube.com/watch?v=hSacbwmVsCs