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 .
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