How about this:

= "Closed week of " & NOW() etc etc

or

=CONCATENATE("Closed week of ",NOW() etc etc)

--
please reply by thread not email
Allllen


"Randy" wrote:

I need the code to create a custom header for only one sheet in my workbook.
I've found code on this site but cannot seem to figure out the correct
syntax. Basically, I need text such as "Closed Week of " displayed followed
by the previous week's date such as May 28, 2006. I have the code for the
date: =(NOW()-WEEKDAY(NOW(),1))+1-7 but I do not know how to put the two
together. This vba novice will appreciate any help!

Thanks!

Randy