convert dd/mm/yyyy ro serial

1 次查看（过去 30 天）

Sophia Chen 2021-1-18

回答： Walter Roberson 2021-1-18

I got some data in excel with date in the formate of dd/mm/yyyy

d = xlsread ('excel.xlsx','D9:D7808')

then I try to do a datenum, but it doesn't work becuase the data is in dd/mm/yyyy

so How could I convert dd/mm/yyyy to yyyy-mm-dd or convert date into serial in some other ways

Thanks

Rik 2021-1-18

Is the data stored as a date in the excel file? Or as text?

Image Analyst 2021-1-18

Here's another chance to read the posting guidelines you skipped over when posting:

After you remember to upload your workbook, we'll be able to help more.

Walter Roberson 2021-1-18

d = readmatrix('excel.xlsx', 'D9:D7808');
d.Format = 'yyyy-MM-dd';

And if you need to,

cellstr(d)

MATLAB Language Fundamentals Data Types Dates and Time

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by