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

0 vote176 views1 answer
Php explode multiple delimiters
PHP
29 votes197 views6 answers
Where like laravel
PHP
0 vote201 views4 answers
Installing bootstrap ui in laravel app
PHP Laravel
0 vote180 views1 answer
If is alphabet php
PHP
49 votes171 views6 answers
Add new column in laravel migration
PHP
3 votes184 views2 answers
Laravel adding condition to relation
PHP
0 vote217 views2 answers
"message": "Call to a member function canNot() on null", "exception": "Symfony\\Component\\Debug\\Exception\\FatalThrowableError",
PHP Symfony
0 vote223 views1 answer
Get taxonomies for custom post type
PHP
18 votes267 views6 answers
Laravel model
PHP Laravel
1 vote221 views2 answers
Display image in php from folder
PHP