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 vote257 views1 answer
Laravel get mysql column datatype
PHP
0 vote267 views1 answer
Bitnami lightsail PHP Fatal error: Out of memory (allocated
PHP
0 vote259 views1 answer
Php magic __dir__ since ?
PHP
0 vote223 views2 answers
Php 8 null safe operator
PHP
0 vote271 views5 answers
How to validate phone number in php procedural programming
PHP
0 vote268 views2 answers
Upload video in laravel
PHP
0 vote216 views1 answer
Display product page title in field cf7
PHP
0 vote312 views1 answer
Laravel access request in provider
PHP Laravel
0 vote294 views1 answer
Laravel migrate test environment
PHP Laravel
1 vote250 views1 answer
How to display user id from a function on a wordpress page
PHP