Need to use IF formula with a Date cell
 

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"?

=IF(C31="","NO DATE",C31)

Vaya con Dios,
Chuck, CABGx3



"Eric Mc" <Eric wrote in message
...
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"?

Try this:

=IF(C31,C31,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Eric Mc" <Eric wrote in message
...
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"?