From 53a7b6d5941af5438f8e1682dad6d28f82dce980 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Mon, 27 Mar 2017 11:02:23 +0800
Subject: [PATCH] SimpleExcel.php

---
 SimpleExcel.php | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 484808cb..829a2b04 100644
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -381,6 +381,9 @@ class Pman_Core_SimpleExcel extends Pman
             if (preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', $v)) {
                 $dataFormat = 'date';
                 $format = empty($format) ? 'YYYY-MM-DD' : $format;
+                $ut_to_ed_diff = 86400 * 25569;
+
+                $v = (strtotime($v) + $ut_to_ed_diff) / $format;
             }
           
             if ( (is_numeric($v) &&  strlen($v) > 1 && substr($v,0,1) == '0' && substr($v,1,1) != '.' )
-- 
2.39.2