Hi All,
I am using a list that contains date, and when i tried to loop through excel sheet it returns me the values of some dates which are not available in excel. Like if the value of 19-Aug-23 or 29-Aug-23 is available in list then it also the return the value of 9-Aug-23 that contains the value of 19-Aug-23 or 29-Aug-23. Below Snap shoots are for reference.
The input list have dates for 340 days in 1-Jan-23 format and Loop from this in excel and find values of that cell which has the current item of list. But it find the single dates (1-9) values for double dates(10-31) which are in list.