Quote Originally Posted by Artik View Post
The problem of the Find method used in the function not working when the function is used as a sheet function is well-known. You have to use another method to search.

..::Edit
I have to backtrack from the last sentences. The problem is with older versions of Excel (2000)
::..

Artik
Yep, I think you're right. I've come up with another way now basically iterating through the range looking for a date value (probably how the find function works anyway )

Thanks all for your help though