$15 To Amend Macro To Find The Next Available Earlier Or Previous Date

[pedros23]

Hi

Thanks.

Please find attached file. Let me know if you have any concern.

Hi,

Thanks for uploading this, however it doesn't seem to work as it should.

As a test I endered 21/01/2014 as the date, however it is picking up 06/09/2012 from sheet Q even though there are many enties after this.

Thanks

After further tests it seems to return the same date for sheet Q no matter what you enter.