MATLAB: How to go from Excel serial date numbers to use in MATLAB without the Financial Toolbox

convertdatedatetimeexcelMATLABserialx2mdate

How do I convert my Excel serial date numbers to use in MATLAB?
I do not have the Financial Toolbox so I cannot use the "x2mdate" function.

Best Answer

Use readtable to import the dates from the spreadsheet as datetimes.
https://www.mathworks.com/help/matlab/ref/readtable.html#btx_238-1-DatetimeType
Alternatively, If the Excel dates have already been imported into MATLAB as numbers then converting from Excel serial date numbers to MATLAB datetime format can be done with the "datetime" function by using the 'ConvertFrom' option.
https://www.mathworks.com/help/matlab/ref/datetime.html
Related Question