i need some help. Im currently working on creating a new spreadsheet and merging everything from the old sheets to the new one so we can start using filters. But the filters wont recognize the date format on my old spreadsheets (00.00.0000). someone at work said that it’s impossible and that I would need to change the date format one by one (to 00/00/0000) before the filter can work on the new one. This is so long and stressing.
So basically I need to put these dates in ascending order, but when I click the filters only the first part of the date ascends and not the entire date. can someone help me please? if your confused but think you can help me please let me know. I’ll elaborate further.
but when i enter the '/' the full date ascends.
i would so appreciate someones help