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 vote163 views1 answer
Javascript function in php json_encode
PHP
36 votes164 views5 answers
Php refresh page
PHP
1 vote169 views2 answers
Php start session if not started
PHP
0 vote201 views1 answer
Blank admin page magento 2.3
PHP
-1 vote194 views3 answers
Delete rows by migration laravel
PHP Laravel
0 vote156 views1 answer
Php array all keys empty
PHP
13 votes165 views4 answers
Php change version linux
PHP
1 vote204 views1 answer
How to set a validation on a value if its not null in laravel php
PHP
3 votes171 views1 answer
Laravel validate max file size
PHP
3 votes176 views3 answers
Php array to csv
PHP