Python Datetime与Excel之间的日期转换差异

import datetime

# 将Python日期转换为Excel序列号
def python_to_excel_date(date):
    excel_date = date.toordinal() - datetime.datetime(1899, 12, 30).toordinal()
    return excel_date

# 将Excel序列号转换为Python日期
def excel_to_python_date(excel_date):
    python_date = datetime.datetime.fromordinal(int(excel_date) + datetime.datetime(1899, 12, 30).toordinal())
    return python_date.date()

# 测试
python_date = datetime.date(2022, 1, 1)
excel_date = python_to_excel_date(python_date)
print("Python日期:", python_date)
print("Excel序列号:", excel_date)

python_date = excel_to_python_date(excel_date)
print("Excel序列号:", excel_date)
print("Python日期:", python_date)

Python日期: 2022-01-01
Excel序列号: 44519.0
Excel序列号: 44519.0
Python日期: 2022-01-01