Linq to filter "Date" column in datatable

[supermanPunch (Arpan)]

@Minal_U ,

We would request you to create a separate Topic, so that we do not mix things up with the Initial Requirement the post and it’s solution has to offer to other users who are looking for the same issue.

For your query on Missing Dates, Have an Initial look on the post below, but for further discussion do create a Separate Topic :

How to get missing dates from excel sheet except saturdays and sundays of respective months

Hi @Siddharth_Kumar1 , We could maybe perform this by first Ordering the Dates retrieved from Excel, And Find out the First Date and Last Date in Order, calculate the Total Days between the two Dates. Then Iterate through these range of days and Checking if it exists in the List already or is a Weekday. Steps as below : Read the Excel sheet as a Datatable, say DT. [image] Intialise an Array with the week day values. Retrieve only the Dates from the Datatable, Order/Sort it and Store it …