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

29 votes210 views6 answers
Where like laravel
PHP
15 votes209 views1 answer
Composer install ignore platform reqs
PHP
1 vote205 views2 answers
How to delete image from aws using laravel 8
PHP
0 vote201 views1 answer
The app function returns the service container instancel
PHP
0 vote200 views3 answers
Serialise php
PHP
0 vote208 views1 answer
Traduction website
PHP
4 votes222 views4 answers
Remove last comma from string php
PHP
0 vote206 views1 answer
Display picture in pdf generated with laravel
PHP
1 vote211 views2 answers
Php string replace space
PHP
9 votes219 views4 answers
Php end session
PHP