How to subtract columns with dates?

[jpy]

Hi everyone, I have the code below that first creates a column with today's date (works) then I subtract an existing column but I get a TypeError. I ran the Dtype function and found that the excl.test column is being returned as an object (string), how can I convert this field into a date? Note, the excl.Date column is formatted as a date yyy-mm-dd.

from datetime import date

excl['test'] = (today)
print(excl.test - excl.Date)

[Larz60+]

There's no way this code can run without error as presented.
Please present full code, or at least working snippet.

[jpy]

This is my first set of code that runs without error.

import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
from datetime import date


#Read excel file
excl = pd.read_excel (r'C:\Users\Family\Desktop\Anaconda\Book1.xlsx')

#Create new column w/data
excl['new_pop'] = (excl.Pop2010 + excl.Pop2020)

#Create a new column/flag

excl['new'] = pd.cut(excl.Pop2010, [0, 89, 90, 180, 365, 500, 750, 900, 1000], right = False)

#Create new excel file with old and new data

print(excl)

excl.to_excel("mastfile.xlsx")

This is my second block which I get errors on.

excl['test'] = (today)
print(excl.test - excl.Date)

[jpy]

The code below got it to work.

from datetime import date

excl['testdate'] = pd.to_datetime(excl['testdate'])

print(excl.testdate - excl.Date)