@manjesh_kumar - Please look closely…
CDate(row(“Grn Date”)).Date. Equals (now.Date))
In the above code, you are checking the Grn Date is equals to Now.date…i believe none of the values in the sheet has the 08/20 date so it is returning the count to 0.
CDate(row(“Grn Date”)).Date > now.Date)
Note: CDate and Datetime.parse will work based on the local system settings, i.e. my local settings MM/dd/yyyy so if use cdate with dd/MM/yyyy format it will thrown an error.
You get it??
Suggestion: Before using LINQ please try the simple for each row and use write Line to print the date values and then based on that use If condition to check you are getting the right results. Once you successfully done this, you can apply the same logic in LINQ query. This way, you will learn how to play with datetime format and datetime parsing etc etc…