that did the trick. However i failed to mention that if there is no data in J column for that specific row match of B & D then it needs to ignore it. with the above if the cell is blank it's displaying 1/1/1900, i need it to display the most recent actual date.