Linq query in excel

Hi, I have to apply a query in excel so that i can apply a date filter which will show upcoming month, what logic I should use.

Problem statement - suppose I have year 2018,2017,2016 and so on and in 2018 we have months like jan, feb,march,april and may

If current month is march so I have to apply a filter so that it will show results only for april and may data.

Thanks!

read excel then convert the date column to DateTime Format then you can where select query where date is >System.DateTime.Today.Month and date < System.DateTime.Today.AddMonths(2)

1 Like

Hi @Divyashreem - Can you help me to apply query where

date is >System.DateTime.Today.Month and date < System.DateTime.Today.AddMonths(2)

Give me your Column name and sample data

I have attached the sample sheet, and I have to apply filter on ‘Due on column’ on the last day of current month.

step 1- first I have to remove upcoming month in 2018 i.e, nov and dec and delete those rows
step 2- then to apply filter on last day of current monthsample.xlsx (2.5 MB)