Hello,

This formula:

=TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")

To produce the following:

Jan 2 - Jan 6

What I would like to do is have the result show this:

Week of Jan 2 - Jan 6

Thanks for the help.