Help with a custom form

[j1717]

First post here, so sorry if this isn't exactly in the right section of the forums. Need some help with creating a custom form. I send the same reports out daily and have created a form which automatically updates the date. Ex: the subject header auto populates as "Daily Status Report - 4/17/2012" (uses current date). Obviously this is simple, i set the initial value to 'Daily Status Report - '&DATE().

However, what I need is to do the same thing, but return the previous weekday. So for today, I would want outlook to return 4/16/2012 and if it were yesterday, I would want it to return 4/13/2012. anybody have any thoughts on how to accomplish this? appreciate the help!