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 vote113 views1 answer
Check array is associative laravel
PHP
2 votes107 views2 answers
Last insert id model codeigniter
PHP
2 votes144 views2 answers
Laravel validate form data unique
PHP Laravel
1 vote99 views1 answer
Convert 1 digit to five digits laravel
PHP
-2 votes105 views1 answer
How to redirect to another page in php after submit
PHP
0 vote134 views1 answer
Laravel checkbox checked
PHP
0 vote156 views1 answer
Database interaction in codeigniter
PHP CodeIgniter
0 vote101 views1 answer
Php sort custom function
PHP
1 vote103 views1 answer
How to find mysql server name in php
PHP
2 votes109 views3 answers
Laravel env production
PHP