convert dates in matlab

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?

Answer 1

[Star Strider]

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

[Sana Ejaz]

Thanks Alot it worked.

[Star Strider]

As always, my pleasure.