I'll look at your table tomorrow then, as I don't have Office in my home computer.

But having your formula return #VALUE! error on the rows that must actually have dates may be because in column T are not dates at all, but datestrings!