This generally works fine, but when I add new rows of data to the end of my spreadsheet, the dates will not format correctly. I have tried copying the format of the correct rows to the rows with the issue, but it still will not work. I also noticed that the correct dates' format appears to be different from the issue dates' format. (See attached images).
Also, when I open the "More Number Formats", both of them are on the same format as seen in the following image:
I am not sure how to fix this issue.. even though it seems pretty simple. I am not able to share my spreadsheet either.. Does someone know how to fix this issue?
How are you adding data?