Q. How to format the date in Excel to the month/day?

If you would like to change the format of the date in Excel.

Right click on the cell and choose Format Cells from the list

Choose from a list of date formats

1. Select the cells you want to format.

2. Press CTRL+1.

3. In the Format Cells box, click the Number page.

4. In the Category list, click Date.