MATLAB: Change Julian date read in from excel to a MM-dd-yyyy form and plotting

exceljulian day

Right now I have julian days that I am reading in from excel and I want to change them to a MM-dd-yyyy format for plotting in matlab. How do I do this?

Best Answer

see https://www.mathworks.com/help/exlink/convert-dates-between-microsoft-excel-and-matlab.html

and perhaps this old question with answers helps

Related Solutions

MATLAB: Converting times from excel file using datetime, datestr, and datenum

datestr uses MM to indicate minutes, you're indicating months above.

datestr(datenum('13:55:20','hh:MM:ss'),'hh:MM:ss')

MATLAB: Way to import time series date string as mm-dd-yyyy

You can convert the data manually:

S1 = '07-12-2011 13:14:15'
D  = datenum(S1, 'mm-dd-yyyy HH:MM:SS');
S2 = datestr(D,  'dd-mmm-yyyy HH:MM:SS')

Best Answer

Related Solutions

MATLAB: Converting times from excel file using datetime, datestr, and datenum

MATLAB: Way to import time series date string as mm-dd-yyyy

Related Question