Formulas plus text in cell

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?
 
S

Simon Lloyd

Almost correct
=Today()-7 & " to
Note the spaces after after the quote and at the end, thats simply t
space it from the formula result
Hi

I am interested in having a formula in a cell along with some text. I
tha
possible? Specifically, I am interested in having a range of dates.
wan
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 thi
possible
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
C

Chadersmith

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
 
P

Pete_UK

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
 
S

Simon Lloyd

What error are you recieving?, PeteUk has given the solution to allow
you to see a date rather than a date serial, if Pete han't solved your
query said:
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


Microsoft Office Discussion' (http://www.thecodecage.com))
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
Click to expand...


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
 
Top