Ramadan2512
Board Regular
- Joined
- Sep 7, 2024
- Messages
- 68
- Office Version
- 2021
- Platform
- Windows
I have a problem to sort dates either from oldest to newest or vice versa
my worksheet with a table and tow columns "G" & "H" to add short dates, but when i try to sort dates I get a mess and dates are not sorted in the right way, when I treid to figure out the problem I found that when I select a date cell, there are some cells like "G272" showing date (in formula bar) as for example 05.11.2024 and other cell like "G274" showing the dates as 01.12.2024 as you can see in attached screenshots . while as you can see in the sheet itself both dates are showing as 24 not 2024
I Tried to copy and paste date format for all cells but still nothing changed in the formula bar
For your info if this might help - I was inserting dates manually first then I added a code to insert date automatically based on other cells value so there are some cells were filled manually and other through VBA
please let me know how to fix that
my worksheet with a table and tow columns "G" & "H" to add short dates, but when i try to sort dates I get a mess and dates are not sorted in the right way, when I treid to figure out the problem I found that when I select a date cell, there are some cells like "G272" showing date (in formula bar) as for example 05.11.2024 and other cell like "G274" showing the dates as 01.12.2024 as you can see in attached screenshots . while as you can see in the sheet itself both dates are showing as 24 not 2024
I Tried to copy and paste date format for all cells but still nothing changed in the formula bar
For your info if this might help - I was inserting dates manually first then I added a code to insert date automatically based on other cells value so there are some cells were filled manually and other through VBA
please let me know how to fix that