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

1 vote214 views1 answer
Laravel Unable to migrate or Make Seeds
PHP Laravel
0 vote180 views1 answer
Laravel subtract date
PHP
0 vote230 views1 answer
How to remove updated_at or use only created_at laravel eloquent ORM
PHP Laravel
2 votes180 views1 answer
Php simple router script
PHP
1 vote171 views1 answer
Laravel log path
PHP
1 vote188 views2 answers
Ini_set('display_errors' 'on') error_reporting(e_all)
PHP
0 vote182 views1 answer
Doctrine query builder order by multiple
PHP
1 vote306 views1 answer
Transaction cakephp 2
PHP CakePHP
3 votes175 views10 answers
Php array
PHP
2 votes183 views2 answers
Increase memory laravel controller
PHP