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!