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

3 votes313 views2 answers
How to get file extension in laravel
PHP
0 vote315 views1 answer
Ci db query error
PHP
2 votes297 views3 answers
Laravel env production
PHP
30 votes323 views4 answers
Date diff php
PHP
0 vote316 views2 answers
Laravel filesystem
PHP Laravel
0 vote312 views1 answer
Php create word pairs from sentence
PHP
0 vote296 views5 answers
Asd
PHP
0 vote299 views1 answer
Php add get to link
PHP
11 votes297 views5 answers
Resource route laravel
PHP Laravel
1 vote328 views2 answers
Php browser detection script
PHP