I have a time sheet that my boss would like me to auto populate the dates on, the problem is, not sure how to accomplish this.



He wants the user to enter the starting date (always a Sun) and it will self calculate the ending date (always on Sat). It will then calculate each day/date going down the page for every day of the week.

I know how to do it in excel and access, but not sure how to do this in word.

I found some code and tried to tweak it to my needs here but it's not working as intended and obviously something's wrong on my end.

Any help would be greatly appreciated. The sample doc is attached. TYIA

Attached Files

timesheet.docm (25.8 KB, 13 views)

You really should use Excel for this. Word is a poor second choice for timesheets as anything to do with date & time calculations is either a complex field-coding undertaking or requires the use of macros.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the response Macropod, but I did some more digging after tuning my search criteria and happened upon a post you made and your solution worked perfectly for me.

https://www.msofficeforums.com/word/...html#post34394

So thank you again for your response and your help!

Yes, and if you look at the field coding in that document, you will see that it is quite complex - just as I said. Word is far from being the ideal tool for this kind of thing and really should only be used as a last resort.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]