Y'ello. I want to create a macro that will save a document with a predetermined day of the week (always the next Saturday) in the title, e.g.



If I were to save the file today the macro would call the document "2013-03-29 Expense Reimbursement"

I know, and thank, MACROPOD for the calculated date formula that accomplishes this in a form field, but I want to do it in VBA for a Macro button.

The "only" piece I'm missing is the bit that would generate the date (I know how to choose a file location and add "Expense Reimbursement" to the title).