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 vote216 views1 answer
Copy file from one directory to another Laravel
PHP
0 vote275 views1 answer
Laravel secure url with query string
PHP Laravel
0 vote222 views1 answer
Editing items in collection in laravel
PHP
14 votes251 views4 answers
How to get javascript variable value in php
PHP
1 vote223 views1 answer
Persian error laravel
PHP
1 vote226 views1 answer
Php filter name
PHP
14 votes204 views3 answers
Log facade laravel
PHP Laravel
1 vote215 views1 answer
Php create url with query sting from array
PHP
3 votes242 views2 answers
Two condition in one laravel query
PHP Laravel
0 vote506 views1 answer
Php json_encode float
PHP