Python convert integer to date

Question

I have this list of integers and need to convert it to date using python.

42222 should be 8/6/2015
42290 should be 10/13/2015
42319 should be 11/11/2015

I get the equal date of the integer when i paste in to excel then format the cell to Date.

why downvotes, now i cant ask another question.. @J.F Sebastian — Liza, Jan 10 '16 at 08:47

score 4 · Accepted Answer · edited Nov 08 '17 at 15:17

4

Excel dates start counting around the year 1900. This will do it:

from datetime import datetime, timedelta

def xldate_to_datetime(xldate):
   tempDate = datetime(1900, 1, 1)
   deltaDays =timedelta(days=int(xldate)-2)
   TheTime = (tempDate + deltaDays )
   return TheTime.strftime("%m/%d/%Y")

>>> xldate_to_datetime(42290)
'10/13/2015'

edited Nov 08 '17 at 15:17

francisco sollima

7,952
4
22
38

answered Oct 15 '15 at 05:31

rofls

4,993
3
27
37

Thank you it saves me :) – Liza Oct 15 '15 at 05:34
1

@Kyrie: this answer is wrong if `xldate` is less than 60. See the answer in the linked question. – jfs Oct 15 '15 at 10:27

Python convert integer to date

1 Answers1