Hi Mikerickson, thanks fo your answer. It turns out that Excel didn't recognize the date type of my data. So i used DateSearial in my Find function, then it works very well.