Assign dates with number

1 view (last 30 days)
stelios loizidis
stelios loizidis on 2 Mar 2022
Hello,
I have the following code
% read from excel file
[~,~,Data]=xlsread("Fuels_2019_2020.xlsx","Fuels_2019_2020")
Fuels_Data=cell2mat(Data(2:17545))' % Fuels_Data: 1X17544
NUM_1=72;
NUM_2=24;
Fuels_DataX=[];
Fuels_DataY=[];
Ch_Day=367 % Ch_Day corresponds=367 6/1/2020, Ch_Day=368 corresponds 7/1/2020, etc.
for i=0:(Ch_Day-1)
Fuels_Data_temX=Fuels_Data(1+(i*24):NUM_1+(i*24));
Fuels_Data_temY=Fuels_Data(NUM_1+1+(i*24):NUM_2+(i*24));
Fuels_DataX=[Fuels_DataX Fuels_Data_temX];
Fuels_DataY=[Fuels_DataY Fuels_Data_temY];
end
What I want is the following: e.g. To have the variable date, to put the date I want (eg date= "6/1/2020") and the code to define that Ch_Day = 367. How can this happen?
Your help is important.

Answers (1)

Benjamin Thompson
Benjamin Thompson on 2 Mar 2022
See the help article "Dates and Time" for information about working with dates and times in MATLAB. There is a function called days that can quickly calculate duration in days from day 0 in your "days" unit. Then if you have more specific questions please post your code and sample input file.
  3 Comments
Benjamin Thompson
Benjamin Thompson on 2 Mar 2022
There are a large number of examples in the documentation. Here is one you can open in the live editor to get started:
openExample('matlab/DifferenceBetweenTwoDatetimeArraysExample')

Sign in to comment.

Tags

Products

Community Treasure Hunt

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

Start Hunting!