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 vote181 views2 answers
Adminlte 3 laravel
PHP Laravel
1 vote112 views1 answer
Laravel data types
PHP Laravel
0 vote193 views1 answer
Symfony refresh endpoints
PHP Symfony
0 vote164 views1 answer
No cache hummingbird
PHP
0 vote205 views1 answer
Laravel reload relationship
PHP Laravel
1 vote194 views3 answers
Laravel syncwithoutdetaching
PHP Laravel
0 vote167 views3 answers
Get index number wordpress loop
PHP
0 vote159 views1 answer
Share link in twitter php
PHP
0 vote174 views1 answer
Laravel array to string error
PHP
16 votes151 views1 answer
League/omnipay v3.0.0 requires php ^7.1 -> your php version (8.0.11) does not satisfy that requirement
PHP