I implemented the date method you demonstrated on one of your videos but it keeps returning a single value 01/01/001; It always moves backward to "01/01/001" even if the excel date column says otherwise. could you please help out. Thanks.
Please let us know your code
Also you can download the code made in videos. You can compare your code to it
I am sure you will find and resolve the issue
code from the video (which didn't work for me) : DateTime dateToBeSelected = Convert.ToDateTime(date);
modified code (Works for me using a dictionary in the function) : DateTime dateToBeSelected = Convert.ToDateTime(testData["ClosingDate"]);