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

1 vote180 views4 answers
In_array validation laravel
PHP
0 vote187 views1 answer
Php array remove value if exists
PHP
34 votes184 views6 answers
Laravel create controller with methods
PHP
0 vote222 views1 answer
Fatal error: require_once(): Failed opening required 'C:\xampp\htdocs\localhost\myapp/public/index.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\localhost\myapp\server.php on line 21
PHP
3 votes215 views2 answers
Laravel create project thorugh composer
PHP
0 vote200 views1 answer
Comment supprimer les onglets WooCommerce dans WordPress
PHP Wordpress
0 vote198 views1 answer
Laravel translation parameters
PHP
7 votes204 views5 answers
Php undefined index
PHP
0 vote240 views2 answers
Fetch data based on month and year in laravel
PHP Laravel
0 vote180 views1 answer
App\Http\Controllers\Validator not found
PHP