MATLAB: Financial toolbox required for excel to matlab date conversion

MATLABStatistics and Machine Learning Toolboxx2mdate conversion

This blows my mind. I have to import dates from an excel spreadsheet and the only way I can convert them to usable dates is by buying the financial toolbox AND the optimization toolbox? This is absurd! Please tell me there is another way to view dates in Matlab without having to spend another $3150. That is more than the cost of Matlab itself! All just to view dates in the IDE. I will be calling them first thing Monday morning to complain.

Best Answer

You can probably convert them using core MATLAB date functions. For a discussion of the differences between MATLAB and Excel date numbers, see the documentation for exceltime (although it does the inverse of what you want).

I generally import Excel dates and times as strings, and do the datenum conversions from them. It’s just easier that way.

Related Solutions

MATLAB: String to Variable conversion

You might find dynamic field names useful. Doc says:

    Generate Field Names from Variables
    [...] 
    For example, create a field name from the current date:
    currentDate = datestr(now,'mmmdd');
    myStruct.(currentDate) = [1,2,3]

MATLAB: How to reverse datenum

datevec or datestr

doc datevec
doc datestr
%For future reference: since you're using datenum, the conversions are probably related to it; if you look at the bottom of:
    doc datenum
it has the inverses.

Best Answer

Related Solutions

MATLAB: String to Variable conversion

MATLAB: How to reverse datenum

Related Question