I have daily data from 1969 to 2018. I want to remove the rows corresponding to 29-02 day from the matrix. How should I proceed?

I have daily data from 1969 to 2018. I want to remove the rows corresponding to 29-02 day from the matrix. How should I proceed?. Is there any in built function for this?

[Rik]

What data type is your data in? Can you provide some code that generates example data?

[Subhra Maity]

Here I have attached a sample excel file.

Answer 1

[Rik]

[num,txt]=xlsread('Sample.xlsx');
t=datetime(txt);
L=day(t)==29 & month(t)==2;
num(L,:)=[];
t(L,:)=[];

[Subhra Maity]

thanks

Answer 2

[Alex Mcaulley]

Another option:

[~,~,raw] = xlsread('sample.xlsx');

raw(contains(raw(:,1),'29/02'),:) = [];

[Subhra Maity]

thanks.. it also does the same. only '29/02' should be changed to '29-02' as per the date format in excel file. :)