John
Do you really want Friday to be the hard-coded day or are you after the
previous working day ?
"John" wrote:
I have a VB code that will stamp the previous days date in the subject of an
e-mail. But on Monday I need it to post Friday's date. How can I do this?
Here is the code that I currently have.
.Subject = "PKG Results - " & Format(Now() - 1, "dddd, mmmm dd,yyyy")
Thank you for your help.