TODAY function question...
 

This should be a pretty easy question. How do I (or can I) insert text and a
function into the same cell.

I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7)

Any help would be greatly appreciated!

Thanks!

TODAY function question...
 

Hi

Try:
="For the week of "&TEXT(TODAY()-7,"dd/mm/yy")

Andy.

"Bob_BLC" wrote in message
...
This should be a pretty easy question. How do I (or can I) insert text and
a
function into the same cell.

I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7)

Any help would be greatly appreciated!

Thanks!

TODAY function question...
 

Worked GREAT, Thank you very much!



"Andy" wrote:

Hi

Try:
="For the week of "&TEXT(TODAY()-7,"dd/mm/yy")

Andy.

"Bob_BLC" wrote in message
...
This should be a pretty easy question. How do I (or can I) insert text and
a
function into the same cell.

I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7)

Any help would be greatly appreciated!

Thanks!

TODAY function question...
 

="for the week " & TEXT(TODAY()-7,"mm/dd/yyy")
will display:
for the week 03/17/2006

--
Gary's Student


"Bob_BLC" wrote:

This should be a pretty easy question. How do I (or can I) insert text and a
function into the same cell.

I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7)

Any help would be greatly appreciated!

Thanks!

TODAY function question...
 

Thanks for the feedback. Glad to help! Don't forget that tomorrow, it will
show 7 days prior to 25th - ie. the today() function is volatile - it will
change with the day!

Andy.

"Bob_BLC" wrote in message
...
Worked GREAT, Thank you very much!



"Andy" wrote:

Hi

Try:
="For the week of "&TEXT(TODAY()-7,"dd/mm/yy")

Andy.

"Bob_BLC" wrote in message
...
This should be a pretty easy question. How do I (or can I) insert text
and
a
function into the same cell.

I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7)

Any help would be greatly appreciated!

Thanks!