Financial Toolbox | ![]() ![]() |
Syntax
DateNum = m2xdate(MATLABDateNumber, Convention)
Vector arguments must have consistent dimensions.
Description
DateNum = m2xdate(MATLABDateNumber, Convention)
converts MATLAB serial date numbers to Excel serial date numbers. MATLAB date numbers start with 1 = January 1, 0000 A.D., hence there is a difference of 693961 relative to the 1900 date system, or 695422 relative to the 1904 date system. This function is useful with MATLAB Excel Link.
Examples
Given MATLAB date numbers for Christmas 2001 through 2004
DateNum = datenum(2001:2004, 12, 25) DateNum = 731210 731575 731940 732306convert them to Excel date numbers in the 1904 system
ExDate = m2xdate(DateNum, 1) ExDate = 35788 36153 36518 36884or the 1900 system
ExDate = m2xdate(DateNum) ExDate = 37250 37615 37980 38346
See Also
datenum
, datestr
, x2mdate
![]() | lweekdate | minute | ![]() |