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 vote200 views3 answers
Php dump
PHP
2 votes210 views1 answer
How to run multiple laravel projects at same time
PHP
0 vote206 views1 answer
Unable to open file error in php
PHP
1 vote251 views2 answers
Php number format 2 decimal no comma
PHP
1 vote202 views1 answer
Laravel select all except some columns
PHP
0 vote219 views1 answer
Combine 2 columns search query laravel
PHP Laravel
17 votes189 views2 answers
Mysql replace a character in a string
PHP
1 vote243 views1 answer
Php artisan cache:clear Failed to clear cache. Make sure you have the appropiate permissions
PHP
0 vote193 views1 answer
Spatie sluggable not working
PHP
0 vote242 views1 answer
Dynamic modal name appending in laravel
PHP Laravel