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 vote175 views8 answers
Syntax error, unexpected token "}", expecting "," or ";" php
PHP
0 vote185 views1 answer
Laravel mysql specified key was too long
PHP
1 vote227 views1 answer
Laravel add auto increment
PHP Laravel
1 vote176 views1 answer
Php create object without clas
PHP
0 vote181 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP
1 vote183 views2 answers
Redrectnh to https n laravel
PHP Laravel
6 votes187 views3 answers
Mkdir recursive php
PHP
0 vote172 views1 answer
Laravel create table with model command line
PHP
0 vote180 views1 answer
Wordpress check if class exists
PHP Wordpress
0 vote218 views1 answer
Wordpress plugin public page
PHP Wordpress