IFERROR Statement in VBA for date

Hi Guys,

Once again i need your expertise to solve my problem and thank you so far the help has been so perfect .

My problem now is that i want to make an iferror statement for the code below & i tried many ways already but it doesn't work.Below is my code..

Please Login or Register  to view this content.

The above code works perfect but only 1 problem. The cell A3 in the code is a date, basically i put a date in it to make it as a start point, but sometimes there will be a date missing so what i want to do is just to say if the match function is error( can't find the date ) then just +1 date. For example : i put 18 September and its error because there is no 18 September in the Data, so i want to search for 19 September.

Any kind of help will be appreciated. Thanks in advance

Bump... anyone can help? even a direction to the website is also fine with me..

Bump..Bump...Bump..

Bump again...anyone can shed some light in this matter?

Hi sixthsense,

Thanks you very much for replying my post, If 18 September doesn't exist then 19 will surely be exist in the data.
The reference cell contain a real date , if you click on the cell ( means edit the cell ) it will show 9/18/2013 , when you didn't click it, it will show 18-Sep-13 ( just telling in case it affect the making of the code )

Please ask me if anything unclear. Thanks

Hi sixthsense,

It works great!! Thank you so much for your help