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 vote161 views1 answer
Autoload_namespaces.php failed to open stream: Permission denied
PHP
18 votes152 views4 answers
Array value search in php
PHP
2 votes229 views3 answers
Spartie all user with role get laravel
PHP
0 vote205 views1 answer
Laravel belongstomany prevent duplicates attach
PHP Laravel
0 vote199 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP
3 votes183 views1 answer
Detecting russian characters on a form in PHP
PHP
0 vote227 views2 answers
Shop page url woocommerce
PHP
0 vote199 views1 answer
Function wp_maintenance_mode() { 763
PHP
0 vote173 views1 answer
Custom pagination laravel css
PHP Laravel
5 votes273 views2 answers
Laravel redirect with message to section
PHP Laravel