How to convert from daily timestep to monthly average?

Hi I currently have a datatable loaded into MATLAB with the first column stating the date in yyyy-MM-dd HH:mm:ss timestep. I then have 11 other columns with data values. I want to convert this data from the current daily timestep stated to mean monthly values for each column of data. How do I go about doing this? I have attached the data file in question.

Answer 1

[Mathieu NOE]

hello Elizabeth

here you are :

Daily_Data = load('example_data.mat');
Daily_Data = Daily_Data.MIKESHEver10calibrationDetailedTSM11;
Monthly_avg_Data=retime(table2timetable(Daily_Data),'monthly','mean');

[Elizabeth Lees]

Thank you perfect answer!

[Mathieu NOE]

you're welcome !