Excel Wont Recognize Date Using Openpyxl

I have a piece of code that converts a unix date to standard U.S. date format. It displays properly in excel, however excel doesn't recognize it as a date. if str(startdate).isdigi

Solution 1:

My mistake was assuming the line below created a date.

date = datetime.datetime.fromtimestamp(int(startdate)).strftime('%m/%d/%Y')

After venturing into the docs (Scary as hell for a noob. Does it get easier?) I realized .strftime('%m/%d/%Y') created a string not a date.

I converted that string to a date using:

date = datetime.datetime.strptime(date, '%m/%d/%Y').date()

Now excel recognizes it as a date.

Hopefully this helps someone in the future.