Get Excel date in php

Avidnyat

In excel date is stored in various formats. One of them is excel timestamp format also called as serial value. So in this format the time is stored in terms of days from 1st jan 1900.
For example ,
if date is having serial value 40634 which corresponds to 1st April 2011 , so to calculate actual date from timestamp following is the code snippet:

echo date(‘Y-m-d’,strtotime(“1900-01-01 + 40634 days”));

about the author

Avidnyat