Date Text
In addition,
I need to know how to write the formula to show the start date (-1) minus 1
day and the end date (+1) plus one day.
Thanks
"Jim" wrote:
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.
|