I want to delete last 3 days date data in excel BUT EXCEL the date format is in general format

Help Studio
1

in this excel i have to delete last 10 days data based on checking M column InvDT
we have to delete the last 10 days rows of data

in my excel M column i have

InvDT
04/30/2024
04/30/2024
04/29/2024
04/29/2024
04/28/2024
04/28/2024
03/13/2024
04/09/2024
04/11/2024

here my excel problem is this dates are coming in string format which conatins spaces in front and back of dates its taking like string i have tried filter data table but idid not work
check my execel attachment
can you try by linq and share me soultion in detail

Thanks in Advance
Fabbucket
SQL.xls (1.2 KB)

2

Cross Reference

3

can you expain me in detail i did not get you

4

You can do by multiple way

1 ) Push this data to the SQL database and delete the data
Delete From TableName Where Date between start date and end date

  1. Or you can get this data table to perform the filter delete the existing record and save the same in your local file

@Fab_Bucket I hope this two will solve your issue.

5

lets do it on the other topic as we already started with the suggestions

6

yes share me solution please