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 vote216 views1 answer
Laravel password verification
PHP Laravel
0 vote173 views1 answer
Send image in request body laravel 6
PHP
4 votes225 views2 answers
Laravel reduce
PHP
1 vote180 views2 answers
Php postgresql
PHP
8 votes174 views4 answers
Php wait
PHP
0 vote179 views1 answer
How to clear artisan in laravel
PHP
2 votes205 views3 answers
Laravel check if field has changed
PHP Laravel
0 vote203 views1 answer
Laravel change error page to open in vscode
PHP Laravel
10 votes190 views4 answers
Print last query laravel
PHP
13 votes185 views6 answers
Wordpress get user by id
PHP