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

4 votes270 views2 answers
Php http authentication
PHP
0 vote249 views1 answer
Laravel $browser->keys alt click
PHP
2 votes286 views1 answer
Laravel delete relationship data
PHP Laravel
2 votes328 views2 answers
Last insert id model codeigniter
PHP CodeIgniter
1 vote268 views1 answer
Select selected fields in laravel join
PHP Laravel
0 vote254 views1 answer
Php $_files
PHP
0 vote241 views1 answer
Php remove nbsp from string
PHP
10 votes252 views3 answers
Session flush laravel
PHP Laravel
12 votes253 views6 answers
Laravel validation
PHP Laravel
0 vote295 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel