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 vote220 views1 answer
Php clone datetime
PHP
0 vote236 views1 answer
Select randomly from mysqli php
PHP
1 vote286 views4 answers
Laravel assign active based on route name
PHP Laravel
2 votes253 views1 answer
Laravel abort
PHP Laravel
0 vote257 views1 answer
Laravel collection diff
PHP Laravel
2 votes257 views3 answers
Laravel check empty string
PHP Laravel
0 vote267 views1 answer
Thousand seperator php
PHP
29 votes231 views1 answer
Php generate random string fixed length
PHP
1 vote247 views1 answer
How to go to index page on clicking a button in html
PHP
7 votes256 views5 answers
Laravel slug
PHP Laravel