Last answered:

07 Mar 2023

Posted on:

05 Mar 2023


Resolved: Day Format doesn't exist in part of Data

The Day Format doesn't appear in the upper part of the column Data after u had converted the Date Format be replacing the . with / . Can u explain why ? Thanks in advance .

1 answers ( 1 marked as helpful)
Posted on:

07 Mar 2023



You can change cells' formats as follows:

Go to Home>>Cells tab>>Format>>Format cells or use the Ctrl+1 shortcut in Excel. 

Then, you need to choose the Date format from the list. 

Sometimes if Custom is selected, cells are not properly formatted. 

Yet, the Year() function in Excel will work both ways, which is what we need for the purpose of this exercise. 

I hope this helps. 


The 365 Team

Submit an answer