The code below got it to work.
from datetime import date excl['testdate'] = pd.to_datetime(excl['testdate']) print(excl.testdate - excl.Date)