Adding Text to Calculated Field

[RoadKill]

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

 

[Tyro]

Need more info. Where are your dates? And where are your cells with the
formulas?

Tyro

 

[PCLIVE]

If it is the current date, then one way:

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

HTH,
Paul

 

[T. Valko]

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

 

[RoadKill]

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.