Excel date format in php

Please use this formula to change from Excel date to Unix date, then you can 
use "gmdate" to get the real date in PHP:

UNIX_DATE = (EXCEL_DATE - 25569) * 86400
  
and to convert from Unix date to Excel date, use this formula:

EXCEL_DATE = 25569 + (UNIX_DATE / 86400)

After putting this formula into a variable, you can get the real date in PHP 
using this example:

$UNIX_DATE = ($EXCEL_DATE - 25569) * 86400;
echo gmdate("d-m-Y H:i:s", $UNIX_DATE);

Similar codes

6 votes332 views2 answers
Where is the php ini file located on server
PHP
7 votes337 views3 answers
How to prevent the Undefined index in php
PHP
0 vote334 views1 answer
Contractors php
PHP
2 votes342 views1 answer
Migrations required field laravel
PHP
0 vote359 views1 answer
Curl multi exec get index
PHP
4 votes354 views3 answers
Php str_replace multiple
PHP
4 votes339 views2 answers
Pretty php
PHP
0 vote335 views1 answer
Yii1 anchor tag
PHP
0 vote360 views2 answers
How to upload two files on same form different path in codeigniter
PHP
0 vote328 views2 answers
Get page title, excerpt or content by Name of the Page
PHP