Have you tried pandas.to_datetime()?
import pandas as pd data = pd.read_excel(path + file_name) pd.to_datetime(data['date_column'])