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 vote147 views1 answer
Hook de pré-commit se déclenche
PHP
2 votes131 views1 answer
Laravel model wherein update
PHP
0 vote130 views2 answers
Minishlink/web-push v5.2.5 requires ext-gmp *
PHP
4 votes138 views4 answers
Carbon get day name
PHP
1 vote147 views1 answer
How to remove jstream package
PHP
8 votes122 views5 answers
Php remove html tags
PHP
0 vote139 views1 answer
Laravel skip a loop if error
PHP
0 vote148 views2 answers
Laravel run schedule only on production
PHP Laravel
0 vote139 views1 answer
Laravel count soft delete data
PHP
0 vote140 views1 answer
Php session name
PHP