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

6 votes372 views3 answers
Write Multi-Line Strings in PHP
PHP
0 vote336 views1 answer
Invalid_scope 'Custom scopes are not allowed for this request.' okta
PHP
15 votes332 views1 answer
Composer install without dependencies
PHP
22 votes346 views6 answers
Convert date php
PHP
0 vote327 views1 answer
Calculate average in eager loading laravel
PHP
1 vote314 views1 answer
Php single quote vs double quote
PHP
0 vote334 views2 answers
Access paginator object attribute in laravel
PHP
3 votes319 views2 answers
Spaceship operator
PHP
1 vote364 views1 answer
Date format in laravel month name day name
PHP Laravel
11 votes287 views4 answers
Laravel 8 password confirmation validation
PHP