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 vote137 views1 answer
Wordpress is_tag function
PHP
5 votes104 views1 answer
Limit 1 1 in laravel query
PHP
20 votes87 views5 answers
Php convert string to json
PHP
0 vote104 views1 answer
Wordpress how to display breadcrumb in child theme programmatically
PHP Wordpress
0 vote107 views1 answer
How run all seeder at once in laravel
PHP
-1 vote88 views2 answers
Php echo alert js
PHP
1 vote87 views2 answers
How to get data from a table in laravel
PHP
-1 vote93 views1 answer
Php include file from file included before
PHP
0 vote135 views1 answer
Laravel Customizing Missing Model Behavior
PHP Laravel
6 votes117 views2 answers
Generate application key laravel
PHP Laravel