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 vote136 views2 answers
Laravel eloquent multiple join with where conditions
PHP
0 vote147 views1 answer
Set config key dynamic laravel
PHP Laravel
0 vote138 views1 answer
Arr::only laravel
PHP Laravel
0 vote128 views3 answers
Php serialize()
PHP
2 votes133 views3 answers
Mysql num rows
PHP
0 vote139 views1 answer
Php retrieve data from database and show in text area greeper
PHP
0 vote130 views1 answer
Upload images php mysql
PHP
12 votes137 views6 answers
Run seeder in migration laravel
PHP
1 vote192 views3 answers
Laravel validate change password
PHP Laravel
2 votes122 views2 answers
Read pdf text in php
PHP