Allllen,

The first scenario worked great! Darn syntax gets me every time!

One more "easy" question: how can I format the date to come out like "May
28, 2006"? Currently I get 5/28/06 11:50:00 a.m.

Thanks!

Randy

"Allllen" wrote:

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