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

17 votes393 views5 answers
?: php
PHP
1 vote396 views2 answers
Laravel eloquent join two models
PHP Laravel
1 vote385 views1 answer
Php convert date and time to iso 8601
PHP
1 vote354 views2 answers
Php get data from url
PHP
7 votes368 views3 answers
Laravel where has
PHP
0 vote380 views1 answer
Wp show logo
PHP
0 vote370 views2 answers
Sweet alert confirm box laravel
PHP Laravel
4 votes325 views4 answers
Nginx codeigniter remove index.php
PHP
0 vote307 views3 answers
Doctrine fixture bundle
PHP
17 votes318 views6 answers
Laravel return validation errors
PHP