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 vote313 views1 answer
Php print string as bytes
PHP
1 vote277 views1 answer
How to use my constants in Larvel
PHP
6 votes279 views2 answers
Refused to connect iframe php
PHP
36 votes269 views5 answers
Php refresh page
PHP
0 vote296 views1 answer
Wordpress add to cart redirect php
PHP Wordpress
1 vote273 views1 answer
Join cakphp
PHP
0 vote317 views1 answer
Custom pagination laravel css
PHP Laravel
0 vote267 views1 answer
Filter child table data from parent laravel eloquent
PHP
0 vote279 views1 answer
Doctrine query builder order by multiple
PHP
0 vote260 views1 answer
Php iife
PHP