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 vote109 views2 answers
Reset Admin password in Magento 2
PHP
8 votes117 views5 answers
Laravel route model binding
PHP
31 votes110 views3 answers
Carbon laravel use
PHP Laravel
17 votes103 views5 answers
Wordpress debug mode
PHP
4 votes107 views2 answers
Laravel DB wherein
PHP
-2 votes100 views1 answer
How to redirect to another page in php after submit
PHP
0 vote110 views7 answers
How to print array in laravel blade
PHP Laravel
5 votes112 views3 answers
Laravel drop column if exists
PHP
3 votes60 views1 answer
Return back with error laravel 8
PHP
1 vote123 views2 answers
How to get data from a table in laravel
PHP Laravel