I receive a lot of reports that generate the date above the time. It then lists lots of times for logging in and logging out. Then it will list the next date followed by lots of times. When I select the cell with times, the date isn't present. I need to sort by date. I'm thinking there's an if statement I can write that recognizes the date and then inserts the date in a column next to the time column. I've tried ISDATE, but it recognizes time as TRUE. Any other ideas? Thank you all a lot!