Accelerating the pace of engineering and science

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 = 1In 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 693960 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
```