Excel serial date number to MATLAB serial date number or datetime format
converts Excel® serial
date numbers to MATLAB® serial date numbers or datetime format.MATLABDate
= x2mdate(ExcelDateNumber
,Convention
)
MATLAB date numbers start with 1
= January
1, 0000 A.D., hence there is a difference of 693960 relative to the
1900 date system, or 695422 relative to the 1904 date system. This
function is useful with Spreadsheet Link™ software.
converts Excel serial
date numbers to MATLAB serial date numbers or datetime format
using an optional input argument for MATLABDate
= x2mdate(___,outputType
)outputType
.
The type of output is determined by an optional outputType
input.
If outputType
is 'datenum'
,
then MATLABDate
is a serial date number. If outputType
is 'datetime'
,
then MATLABDate
is a datetime array. By default, outputType
is 'datenum'
.