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 vote295 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
0 vote245 views1 answer
Check which php.ini file enabled from code
PHP
1 vote261 views1 answer
Php8
PHP
0 vote275 views1 answer
File original extensions laravel
PHP
0 vote296 views2 answers
Limit string syntax
PHP
2 votes355 views2 answers
Wordpress theme The link you followed has expired.
PHP Wordpress
1 vote259 views4 answers
Dynamic base url codeigniter
PHP
8 votes246 views1 answer
Get all routes laravel
PHP
0 vote260 views1 answer
Dateinterval hh mm ss
PHP
3 votes276 views1 answer
How to change add to cart button in wordpress
PHP