Hi all,
I have a very large spreadsheet with value dates for each row, I normally filter it by dates and also use the “newest to oldest” filter but for some reason my dates are not formatted correctly so some are not included in the year drop down and instead are separate to the other dates. Not sure if that makes sense I could give a screengrab unless there is a quick fix to make everyday the same format so I can filter them properly?
Many thanks all!
I have a very large spreadsheet with value dates for each row, I normally filter it by dates and also use the “newest to oldest” filter but for some reason my dates are not formatted correctly so some are not included in the year drop down and instead are separate to the other dates. Not sure if that makes sense I could give a screengrab unless there is a quick fix to make everyday the same format so I can filter them properly?
Many thanks all!