How do I read a date in Excel format in Python?

Question

How can I convert an Excel date (in a number format) to a proper date in Python?

Accepted Answer

You can use xlrd.

From its documentation, you can read that dates are always stored as numbers; however, you can use `xldate_as_tuple` to convert it to a python date.

Note: the version on the PyPI seems more up-to-date than the one available on xlrd's website.

Solution