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 vote110 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP
0 vote112 views2 answers
Sort names alphabetically php
PHP
60 votes117 views4 answers
Echo errors php
PHP
0 vote130 views1 answer
Laravel vue build production
PHP
0 vote138 views1 answer
Laravel convert eloquent collection to collection
PHP
0 vote165 views1 answer
Woocommerce php products list div
PHP
0 vote151 views1 answer
Laravel sanctum axios Unauthenticated
PHP
1 vote139 views2 answers
Wp cli command activate plugin
PHP Wordpress
2 votes140 views1 answer
Laravel pivot table model
PHP Laravel
7 votes159 views3 answers
Laravel where has
PHP Laravel