Oops, yes, the 3/2 is a date. But it is not in any fields presently. E2 on my
Availability sheet is a calculated field itself and is set as a number. So at
this point it is just text.

Now I suppose we could add it to another sheet or group of hidden cells if
need be.

"RoadKill" wrote:

This is the calcualtion in my cell H4:

=IF(Availability!$E$2<=0,"Not Available","Available")

What I would like to see is if it is possible to add the date to the field
so that it looks like "3/2: Available". Is that possible, or do I have to do
this:

=IF(Availability!$E$2<=0,"3/2: Not Available","3/2: Available") for each cell?

Thanks