View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chadersmith Chadersmith is offline
external usenet poster
 
Posts: 12
Default Formulas plus text in cell

Hi,

I am interested in having a formula in a cell along with some text. Is that
possible? Specifically, I am interested in having a range of dates. I want
one cell to be: "=Today()-7" "to"
The next cell to the right would be: "=Today()"

Our format will not allow for another active cell to be used. Is this
possible?