x2mdate (Financial Toolbox)

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 in 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.

`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 in 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.

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 MATLAB Excel Link.

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

See Also

datenum, datestr, m2xdate

wrkdydif xirr