Thread: Formula req
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Formula req

Hi try
= your-formula & " Weeks"

where your-formula is the one you wrote down
regards
Paul

santaviga wrote:
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