Analyzing dates from excel file

I have a very large excel file in which column A contains information for every minute of every day for a year. Each row increases by 1 minute starting from Jan 1st at midnight. How do I import the file into matlab and analyze the data in columns B & C on a month-by-month and week-by-week basis? I know how to write the code to do the analyzing that I need, but I am unsure how to have it go through the excel file to check for dates. Any help would be greatly appreciated!

Answer 1

[Abhishek PH]

If it is an excel file it can be easily read by using this code

a = xlsread('Filename.xlsx');
A = a(:,1);       % Reads column 1

Similarly other columns can be read. As for the week and monthly readings, you can read the data like this:

week = a(1:10080,1)    % Reads week data for 1 week : 7*24*60 = 10080