I am using =LEFT in B1 to isolate the 1st 8 characters of A1. In C1 I want to test whether B1 is a date. If it is a date, I want to include the status in an IF statement. I've tried ISNUMBER but it returns false. I guess there is no equivalent function for a date. Is there a formula that will accomplish this?