Maybe this:

Assuming E2 is a date and "3/2" is that date in month/day format:

=IF(Availability!$E$2<=0,"Not Available",TEXT($E$2,"m/d")&" Available")


--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
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