Sort not working on a date column

[datadummy]

I am try to sort a date column and am selecting the "Sort Oldest to Newest" and its not sorting appropriately and I have no idea why. Secondly I have noticed that when I click on the filter for the column 2021 is not being recognized by the filter and again I have no idea why. Any thoughts?

 

[Zot]

Try click Format>Cell and check if the cell is formatted as Date or General. Most likely it is not date as data entered.

 

[datadummy]

Try click Format>Cell and check if the cell is formatted as Date or General. Most likely it is not date as data entered.

I just checked and all the cells of concern are formatted appropriately as Date. For some reason every date with a 2020 label is sorting appropriately, it appears the main concern is any 2021 date as those seem like they're not registering. Is there any known issues with excel recognizing 2021 dates?

 

[Zot]

I just checked and all the cells of concern are formatted appropriately as Date. For some reason every date with a 2020 label is sorting appropriately, it appears the main concern is any 2021 date as those seem like they're not registering. Is there any known issues with excel recognizing 2021 dates?

Never hear such a problem.

Please update your profile to show your Excel version to let everyone know. Excel is not 100% compatible on each version

 

[MARK858]

In a separate column put the formula

=ISNUMBER(A2)

changing the A2 to the first cell with a date in and drag the formula down.

Do all the results come up as TRUE or FALSE?

 

[datadummy]

In a separate column put the formula

=ISNUMBER(A2)

changing the A2 to the first cell with a date in and drag the formula down.

Do all the results come up as TRUE or FALSE?

That did the trick! There was a blank line that my eyes kept skimming over but the "false" identified it and I deleted the row and now all is working appropriately. Thanks for your help!!!

 

[Zot]

That did the trick! There was a blank line that my eyes kept skimming over but the "false" identified it and I deleted the row and now all is working appropriately. Thanks for your help!!!

When dealing with numbers in long rows, our eyes play trick on us ?

 

[MARK858]

@datadummy You're welcome, it's not exactly the reason I posted the ISNUMBER formula but happy it showed up where the problem was.