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 vote284 views5 answers
Laravel collection methods
PHP Laravel
6 votes299 views2 answers
Php mkdir if not exists
PHP
-1 vote259 views1 answer
How to upgrade php in mac mojave
PHP
0 vote276 views1 answer
Php if around html
PHP
1 vote265 views1 answer
DateTime and Timestamps
PHP
20 votes266 views3 answers
Php file exist
PHP
5 votes391 views3 answers
Get result count codeigniter
PHP CodeIgniter
0 vote271 views1 answer
Old codestar radio field
PHP
0 vote303 views2 answers
Laravel login register api
PHP Laravel
3 votes240 views5 answers
Php error log
PHP