I am struggling with this error for a couple of hours. I trying to upload a xlsx file which contain dates. In that some of the dates are calculated based on other dates .
The issue which I am getting on this is some of the date fields it is subtracting one day automatically while uploading . But in the xlsx sheet it is displaying properly.
Any idea what is wrong with the my code . Is this one related to my code or could be xlsx problem?
This is the code to get the date from the excel
PHPExcel_Style_NumberFormat::toFormattedString($objWorksheet->getCellByColumnAndRow(9,$row)-
>getCalculatedValue(), "M/D/YYYY");
Without more code it is hard to guess where the date is changed. Depending on how the date is handled, could it be that it is a timezone issue?