I am very close to finding a solution, but have not used the IF function much.

I have one row where a date is input by a user (Oldest Pending Date). Once
that date is in, then that date is transposed at the bottom of the worksheet
using =C31. If nothing is put in C31 then of course, it returns 01/00/00.

I would like the formula to read any data in Row 31. If there is a date,
transpose that date - essentially, that data - to the corresponding cell. IF
THERE IS NO DATA, then put "NO DATE" in the corresponding cell. The trouble
I run into is the IF(C31="no data") portion. How do you tell the formula to
look for "nothing"?