Adding Text to Calculated Field

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

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
 
If it is the current date, then one way:

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

HTH,
Paul
 
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")
 
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.
 
Back
Top