Skip to main content

how to delete rows with the date in excel

Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record

how to delete rows with the date in excel

Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record

Hey ​@abishek22225 ,

You can use Datetime:Substract, pass system date, then you can compare it with the excel date. 

 


Thanks for the reply when i have done this all that you said but i have a problem in when it delete the 5 row the 6 row place it in 5 row so it was not deleting the row properly what should i do now

kindly help me in this


Reply