Formulas plus text in cell

  • Thread starter Thread starter Chadersmith
  • Start date Start date
C

Chadersmith

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?
 
Hi Simon,

I am receiving an error with the text you suggested. I directly entered:

=TODAY()-7 & " to "

but am still getting an error. Any other ideas? Or did I enter something
incorrectly?

Thanks,
Chad
 
If by "error" you mean that you have a number followed by " to", then
you will need to do this:

=TEXT(TODAY()-7,"dd/mm/yyyy") & " to "

Hope this helps.

Pete
 
Back
Top