Julian day to date

Question

Daphne PARLIARI 2020-8-29

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/586178-julian-day-to-date

评论： Med Aymane Ahajjam 2023-1-31

KALAMARIA_2007.xlsx

Hello everyone.

I have a simple (hopefuly) question. In the attached excel file, column C contains year and column D the day of year (e.g. 01/01/2007 is day 1 and 31/12/2007 is day 365).

Is there a way to convert this date type into the format dd-mm-year, with each of the three numbers in separate columns (one for the day, one for the month and one for the year)?

Thank you in advance!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

the cyclist 2020-8-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/586178-julian-day-to-date#answer_486752

编辑：the cyclist 2020-8-29

在 MATLAB Online 中打开

Here is one way:

dateTable = readtable('KALAMARIA_2007.xlsx','Range','C:D');
julianDate = datetime(dateTable.YEAR,1,dateTable.JULIANDAY);
julianY = year(julianDate);
julianM = month(julianDate);
julianD = day(julianDate);