Thread: Formula req
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
santaviga santaviga is offline
external usenet poster
 
Posts: 178
Default Formula req

I have cells with the following formula in them
(=INT(TODAY()-INDEX('Galashiels Tea Fund'!$1:$1,1,MATCH("x",'Galashiels Tea
Fund'!4:4)))/7) this returns a number in the cell with reference to the date,
Is there a way I can also insert a text to go along with the number at the
end of the formula. e.g. (6 Weeks) the 6 is generated by the current formula
all I need is to add weeks as text.


Thanks



Mark