I have been trying to type a date in a column in MS excel. But excel always reads it as a serial number. How Can I get it to display the date as it is in date format. I have the next column formatted/ formulated to display the day of the date in the previous column.