Hi, i am enclosing a sheet to help explain. But basically, i have in cell A1 a string of dates and they are NOT in order. I have a list of dates in column B and what i want to know is if the date say in cell B1 is in the list of dates shown in cell A1.
Not sure how to do this. i tried converting cell A1 to text using Text(B1,"m/dd/yyyy") and then using countif but this didnot work.
Any thoughts?
Bookmarks