convert dates in matlab
2 ビュー (過去 30 日間)
古いコメントを表示
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?
0 件のコメント
採用された回答
Star Strider
2019 年 6 月 17 日
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
2 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!