MATLAB: Convert dates in matlab

datesexcel

Hi all,
Need urgent help. I have dates in excell in a format of 19800101(this is 1st jan 1980).
I want to convert them to datenum in matlab.I have attached the excell file with the date column.
I want to convert dates in this column to matlab dates of any format.I tried converting it using different functions but failed.
would someone be able to help?

Best Answer

  • Try this:
    D = xlsread('dates.xlsx');
    Ds = num2str(D,'%d');
    Dn = datenum(Ds, 'yyyymmdd');
    Check = datevec(Dn) % Check Conversion (Delete Later)
    The first five :
    Check =
    1986 1 2 0 0 0
    1986 1 3 0 0 0
    1986 1 6 0 0 0
    1986 1 7 0 0 0
    1986 1 8 0 0 0