Convert Excel Days Date to real date Pandas

PHOTO EMBED

Mon Oct 18 2021 02:56:55 GMT+0000 (Coordinated Universal Time)

Saved by @ianh #python #datetime #pandas

df['SettlementDate'] = pd.TimedeltaIndex(df['SettlementDate'], unit='d') + dt.datetime(1900,1,1)
content_copyCOPY