Date formatting ("dates since ...")

[andrewtweber]

First, thank you for this amazing library.

The date formatting seems to be really bad though. It converts "4/5/2014" into "04-05-14". This format makes it very hard to convert back into a date. PHP strtotime() interprets it as May 14, 2004. At the very least, the year should be 4 digits, that would help a lot.

Additionally, Excel sometimes stores dates as simply an integer representing the number of days since January 1, 1900 (or January 1, 1904 on Mac for some reason). It would be excellent if those could also be converted to date strings as well.

[dilshod]

Have you tried --format option? You can specify %d/%m/%Y

[andrewtweber]

No I had not, sorry! That definitely helps. However, the "days since January 1, 1900" would be a nice feature to have in the future. Thanks.

[dilshod]

Can you send sample xlsx file? i'll try it

[rickhuizinga]

I have a sample file for the "days since January 1, 1900" issue. See the "Sale Date" column in the following file:https://www.dropbox.com/s/8jn4y8ksmtysfqw/2014.03.14_Entire%20County.xlsx