To Whom It Concerns:



Thank you in advance for your time. Previous assistance on this forum has made my paperwork much, much easier. I'm hoping I can simplify the process even more by adding a macro in my attendance report template.

Basically, I want a date to be generated whenever the template is opened that is the Saturday of that week. My organization operates on a Sunday through Saturday schedule.

Once the Saturday date in question (reflecting the reporting period) is entered into the form field, I already have the other dates generated automatically on the template. The question is: can I create a macro that will automatically generate the Saturday for that week? It has to be the SUBSEQUENT Saturday, not the preceding Saturday.

e.g. if I opened the document anytime this week (reporting period 11/03/13-11/09/13), including Saturday 11/09/13, I would want it to generate the date 11/09/13 in a form field.

IF this is possible, I have one follow-up question:

When saving the template, it generates a .docx. I want it to keep doing this. If a macro is present in the template, will it prompt me to save a .docm? If YES, is there a way to disable it and just have it save without the macro? I don't want the macro to persist in the documents it creates. This would sound alarm bells by those receiving the attendance reports.

Thanks in advance!

Sincerely,

CrabApple