fork download
copy 
  1. <?php
  2.  
  3.     function excelDateToDate($readDate){
  4.         $phpexcepDate = $readDate-25569; //to offset to Unix epoch
  5.         $timestamp = strtotime("+$phpexcepDate days", mktime(0,0,0,1,1,1970) / 1000);
  6.         return date("d-m-Y", $timestamp);
  7.     }
  8.  
  9.  
  10. echo excelDateToDate(41137);
Success #stdin #stdout 0.03s 24400KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
16-08-2012
https://ideone.com/6udwhC
language:
PHP (php 7.3.5)
created:
8 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!