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 vote354 views1 answer
Wordpress disable posts
PHP Wordpress
0 vote340 views1 answer
Onclick call route laravel
PHP
1 vote318 views1 answer
Wp get image alt
PHP
0 vote381 views1 answer
Wordpress deactivate widgets gutenberg
PHP Wordpress
0 vote270 views1 answer
Php set int
PHP
0 vote297 views1 answer
Document ready wordpress
PHP
0 vote328 views1 answer
Wp_post wordpress
PHP Wordpress
11 votes295 views2 answers
Update packages composer global
PHP
3 votes319 views4 answers
Input if not null laravel
PHP
0 vote363 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel