I have an excel file with several date columns that are formatted ex. "4/6/2023 10:35:47 AM
When I use readxl::read_xlsx the column comes in as a string column that look like ex. "45022.358182870368"
How can I get this formatted in a way that I can easily arrange or summarize to see the earliest and latest dates in each column?