I want to write linq query where i have to check "Task " column contain expires then check “date” column if date is in the range of 15 days start from today. (today is 06/11/2021 to 06/20/2021). then check in “Status” column if it is null then update “status” column to ‘present’. else remaining data are same as it is. Please help on these. I have tried to write multiple query to find result but i am not getting exact result.
Data.xlsx (8.7 KB)