I have an excel file with columns Date_of_visit & As_of_date and 2 rows. While I'm loading into data frame one row is in date format and another in numeric. I want to format the column into same format.
Could you please create a reprex to provide us with some of the data you are working with and what you are trying to do to it. A reprex consists of the minimal code and data needed to recreate the issue/question you're having. You can find instructions how to build and share one here:
My first idea would be to use the date formatting function on the strings like this