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 vote107 views1 answer
Slim disable display error details
PHP
1 vote121 views2 answers
Laravel session put method
PHP
22 votes119 views5 answers
Update or insert in laravel
PHP
9 votes108 views5 answers
Get Current Page URL in PHP
PHP
0 vote122 views1 answer
Get basename without extension Laravel
PHP
52 votes135 views6 answers
Php redirect
PHP
2 votes108 views3 answers
How to change the colum type in migration laravel
PHP
4 votes134 views1 answer
Get client size in laravel
PHP Laravel
12 votes121 views3 answers
Uninstall php ubuntu 18.04
PHP
3 votes111 views5 answers
Php artisan jwt secret
PHP