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

-1 vote155 views2 answers
Php realpath
PHP
0 vote133 views1 answer
Macos how host laravel website on localhost and intranet wifi
PHP
2 votes134 views2 answers
Convert multidimensional array into single dimension php
PHP
13 votes172 views6 answers
Prefix laravel route
PHP Laravel
6 votes154 views4 answers
Laravel spatie asigne role
PHP Laravel
3 votes143 views5 answers
Implode and explode in php
PHP
0 vote132 views1 answer
Subtract some days php
PHP
2 votes105 views1 answer
Laravel delete model with all relations
PHP
0 vote158 views1 answer
Create command laravel sample parameter
PHP Laravel
0 vote140 views2 answers
Rearrange array index php
PHP