Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 01-09-2012, 01:59 PM
CrabApple CrabApple is offline Creating a consecutive list of dates in a MS word document whenever it is accessed Windows 7 64bit Creating a consecutive list of dates in a MS word document whenever it is accessed Office 2010 64bit
Novice
Creating a consecutive list of dates in a MS word document whenever it is accessed
 
Join Date: Jan 2012
Posts: 17
CrabApple is on a distinguished road
Default

Dear Macropod,

I apologize for not being clearer in my post. Employees do indeed fill out their attendance report for every day of the week, regardless of whether they worked a particular day or not. What I meant was that they fill out their attendance report on different days (some, if they're not being good little worker bees, will do them the following week--but I'm not looking to fix that problem).

My personal solution requires me to fill out my attendance report on a particular day (I chose Tuesday). Since I chose Tuesday, all of the formulas reference {DATE} in the Tuesday date box. If I entered the template I devised today (Monday) and pressed F9 to update all of the fields, all of the dates would be off.

The way our form is devised our week actually ends on Saturday. My boss wants to know if there is a way to allow someone to fill out his/her attendance report any day of the week. That is to say, the form would "know" that, if Sally wants to fill out the form on Wednesday, it'll adjust accordingly and all of the fields will display the right dates. Whereas, if I gave Sally my template right now, it would not work because my template requires someone to fill out their attendance report a particular day.

I apologize if I'm still being obtuse.

Thanks again for your help!

Del
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a consecutive list of dates in a MS word document whenever it is accessed seach an Excel list elements in word document 7ajar Word VBA 5 03-16-2011 12:38 PM
Filling the consecutive cell by day. aligahk06 Excel 1 09-15-2010 08:17 AM
Creating a consecutive list of dates in a MS word document whenever it is accessed Can I print a log showing when my email account was accessed partner Outlook 1 03-09-2008 07:07 AM
creating a categories list owwiii Outlook 0 08-09-2007 01:56 PM
Creating a Map From a List of Addresses aleccamp Excel 0 11-19-2005 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft