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 vote140 views1 answer
Can i install php7.4 inside vagrant homestead
PHP
0 vote102 views1 answer
Application/x-www-form-urlencoded curl php
PHP
0 vote176 views1 answer
Laravel latest from relationship
PHP Laravel
2 votes122 views1 answer
Php filter only numbers
PHP
0 vote142 views1 answer
Login and registration form using php and mysqul
PHP
7 votes135 views3 answers
Php array_intersect
PHP
5 votes123 views3 answers
Enum table in laravel
PHP
0 vote144 views1 answer
Composer require rtconner/laravel-tagging
PHP
-1 vote187 views1 answer
Codeigniter get num_rows
PHP CodeIgniter
40 votes155 views4 answers
Clear cache in laravel without artisan
PHP