Delete rows which are before some date

[Life_Hacks]

Hi

I have a excel where i want to delete road based on condition

If running month is Jan to March of current year then
Then delete the rows which are before 30 oct of previous year

And if current /bot running month is aug to oct then delete the rows which are before 31 march of same year or some might be fr om previous year as well…

Here
Col names are

Name| city| admissiondate |age

We need to delete row based on admission date column .

TIA !

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Life_Hacks,

Please refer steps mentioned in below post:

How to delete particular row in excel

HI @Baby123 Try like this Use Excel Application and read range activity and store the value in the datatable Use Filter Datatable activity and configure it. [image] Use write range and give the new sheet name and check on add headers in properties and write the data table in the new sheet. Delete the old sheet using modern activity(Find the activity after enabling show modern in the filters) [image] Or you can use that sheet as the initial inout with no changes Hope this Help…

In the filters, you. A provide conditions for the month to keep/delete certain rows.

Regards
Sonali