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 vote271 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
0 vote320 views1 answer
How uplpoad video in laravel
PHP
1 vote236 views1 answer
How to setup cronjob on cakephp on share hosting
PHP
0 vote238 views1 answer
$request laravel undefined inside function query
PHP
0 vote250 views1 answer
Open php tag
PHP
0 vote245 views1 answer
Laravel check if postback
PHP
0 vote234 views1 answer
Date en français - php
PHP
0 vote316 views1 answer
Laravel array search blade
PHP Laravel
7 votes293 views3 answers
Laravel random query
PHP Laravel
0 vote247 views1 answer
The plugin generated 14 characters of unexpected output during activation. if you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin
PHP