Adding Text to Calculated Field
If it is the current date, then one way:
=TEXT(TODAY(),"m/dd") & ": " & IF(Availability!$E$2<=0,"Not
Available","Available")
HTH,
Paul
--
"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
|