View Single Post
 
Old 01-09-2012, 01:59 PM
CrabApple CrabApple is offline Windows 7 64bit Office 2010 64bit
Novice
 
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