="Closed week of " & text((NOW()-WEEKDAY(NOW(),1))+1-7,"mmm dd, yyyy")

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

--

Dave Peterson