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 vote235 views2 answers
Laravel eloquent select case when
PHP
0 vote267 views1 answer
Wordpress disable errors
PHP Wordpress
2 votes205 views1 answer
Laravel instal
PHP
0 vote220 views1 answer
How to convert php code to html
PHP
0 vote263 views1 answer
Laravel passport generate key
PHP Laravel
0 vote255 views1 answer
Pusher-php-server laravel
PHP Laravel
0 vote230 views1 answer
Php pass function as callback
PHP
0 vote262 views1 answer
Comment supprimer les onglets WooCommerce dans WordPress
PHP Wordpress
1 vote223 views1 answer
Send message php code stackoverflow
PHP
61 votes213 views2 answers
Php get intersection of two arrays
PHP