Convert date string to MS-Excel serial date with PHP / PHPを使用して日付文字列をMS-Excelシリアル日付に変換するメモ

/**
 * @param  $dateString, e.g. '2018-05-25'
 * @return MS-Excel serial date
 * Convert date string to MS-Excel serial date.
 */
function getExcelSerialDate($dateString) {
    $baseDate = new DateTime('1900-01-01');
    $interval = $baseDate->diff(new DateTime($dateString));
    $serial = $interval->format('%a') + 2;
    return $serial;
}

/**

* @param $dateString, e.g. '2018-05-25'

* @return MS-Excel serial date

* Convert date string to MS-Excel serial date.

function getExcelSerialDate($dateString) {

$baseDate = new DateTime('1900-01-01');

$interval = $baseDate->diff(new DateTime($dateString));

$serial = $interval->format('%a') + 2;

return $serial;

}

別件

日付から曜日

=IF(ISBLANK(A1),"",TEXT(DATE(A1,B1,C1),"aaa"))

1	=IF(ISBLANK(A1),"",TEXT(DATE(A1,B1,C1),"aaa"))

コメントを残す