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 vote216 views1 answer
How to install or setup sanctum for laravel api authentication
PHP Laravel
0 vote171 views1 answer
The last ship -inurl:(htm/html/php/pls/txt) intitle:index.of "last modified" (mp4/wma/aac/avi)
PHP
5 votes160 views3 answers
Enum table in laravel
PHP
-4 votes167 views3 answers
Update wordpress query
PHP Wordpress
1 vote191 views1 answer
Deactivate woocommerce breadcrumbs
PHP
0 vote181 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP
1 vote199 views1 answer
How validate the becrypt password in laravel
PHP Laravel
0 vote169 views1 answer
Symfony refresh endpoints
PHP
3 votes166 views2 answers
Php post curl json
PHP
0 vote179 views2 answers
Laravel filemanger choose multiple images
PHP