Hello Leith Ross,
Thanks a ton, you have been really trying to help me out.
Unfortunately, I am not that an expert in MS Excel and so have not been able replicate the formula to get it working in the sheet that I need.
I have 2 sheets, where the formula should be in Sheet2 and the data for matching the Item#, Day# and the dates are in Sheet1.
Request you to please help me get this formula working in the sheet that I have attache in this response.
Thank you once again for your time.
Bookmarks