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

2 votes178 views3 answers
Laravel many to many relationship with pivot table
PHP
1 vote231 views2 answers
Create role spatie
PHP
0 vote183 views1 answer
Php code add text on existing pdf file
PHP
3 votes283 views2 answers
Remove get parameters from url php
PHP
6 votes209 views6 answers
Laravel collection pluck
PHP Laravel
0 vote173 views1 answer
Livewire model bind item in array
PHP
0 vote247 views1 answer
Order table in laravel
PHP
0 vote260 views1 answer
Comment exiger une longueur minimale de commentaire dans WordPress
PHP Wordpress
0 vote166 views1 answer
.phtml
PHP
0 vote221 views1 answer
Destroy session codeigniter 3
PHP CodeIgniter