Financial Toolbox™

x2mdate

Excel^® serial date number to MATLAB^® serial date number

Syntax

MATLABDate = x2mdate(ExcelDateNumber, Convention)

Arguments

ExcelDateNumber

A vector or scalar of Excel serial date numbers.

Convention

(Optional) Excel date system. A vector or scalar. When Convention = 0 (default), the Excel 1900 date system is in effect. When Convention = 1, the Excel 1904 date system is used.

In the Excel 1900 date system, the Excel serial date number 1 corresponds to January 1, 1900 A.D. In the Excel 1904 date system, date number 0 is January 1, 1904 A.D.

Due to a software limitation in Excel software, the year 1900 is considered a leap year. As a result, all DATEVALUEs reported by Excel software between Jan. 1, 1900 and Feb. 28, 1900 (inclusive) differ from the values reported by 1. For example:

In Excel software, Jan. 1, 1900 = 1
In MATLAB, Jan. 1, 1900 = 2

Vector arguments must have consistent dimensions.

Description

DateNumber = x2mdate(ExcelDateNumber, Convention) converts Excel serial date numbers to MATLAB 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 Spreadsheet Link™ EX software.

Examples

Given Excel date numbers in the 1904 system

ExDates = [35423  35788  36153];

convert them to MATLAB date numbers

MATLABDate = x2mdate(ExDates, 1)

MATLABDate =

      730845      731210      731575

and then to date strings.

datestr(MATLABDate)

ans =

25-Dec-2000
25-Dec-2001
25-Dec-2002

x2mdate

Syntax

Arguments

Description

Examples

See Also