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?

Formulas plus text in cell
 

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

Is this what you wanted?Chadersmith;444257 Wrote:
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?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123196

Formulas plus text in cell
 

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

"Simon Lloyd" wrote:


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

Is this what you wanted?Chadersmith;444257 Wrote:
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?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123196

Formulas plus text in cell
 

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

On Aug 7, 12:41*pm, Chadersmith
wrote:
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



"Simon Lloyd" wrote:

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

Is this what you wanted?Chadersmith;444257 Wrote:
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?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:http://www.thecodecage.com/forumz/sh....php?t=123196- Hide quoted text -

- Show quoted text -

Formulas plus text in cell
 

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 can you eloborate?Chadersmith;444883 Wrote:
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

"Simon Lloyd" wrote:


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

Is this what you wanted?Chadersmith;444257 Wrote:
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?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('The Code Cage - Microsoft Office Help -
Microsoft Office Discussion' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Formulas plus text in cell - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=123196)




--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123196