Forum Discussion
Excel Date format problem
Hi, I tried everything but seem to be stuck here with this issue though I believe I might be missing a simple solution. I have two dates: 03/09/2021 02/09/2021 Excel is taking it as m/d/yyyy ...
What are the sources of the dates?
Behind the formatted display is a number and no matter how you format it, if the number stays the same, then March and February are going to be the months.
Excel deals with dates as serial numbers, beginning with date #1 being January 1, 1900. So you need to get to the unformatted date--or at least to recognize its presence--in order to get Excel to be dealing with the dates you have in mind. Just changing the format isn't dealing with the underlying reality that Excel sees.
Here's a screen capture showing, in column B, the serial numbers behind the dates in column A