Hi. I'm hoping someone will give this a try. I'd like to enter a function
into each cell in column D so that the total hours worked for the previous
week appears each Sunday. For instance, cell D6 would display 11, the sum
of C2:C6 (note this is a short week). Cell D20 would display 22.5, the sum
of C7:C20. On some days, no work at all is performed, but on other days
multiple tasks are performed. The only cells in column D that should
display a value are the Sunday's... all other cells should display nothing.
Thanks very much for your help!!

Gregg.

A B
C D
1 DATE TASK
DAILY_HRS WEEKLY_HRS
2 Thu, Mar-01-2009 Stuff I worked on 4
3 <blank
4 Fri, Mar-02-2009 Stuff I worked on 5
5 Sat, Mar-03-2009 Stuff I worked on 2
6 Sun, Mar-04-2009 <blank
7 Mon, Mar-05-2009 Stuff I worked on 4
8 <blank Stuff I worked on 2
9 <blank Stuff I worked on 1
10 Tue, Mar-06-2009 Stuff I worked on 2
11 <blank Stuff I worked on 3
12 Wed, Mar-07-2009 Stuff I worked on 2
13 <blank Stuff I worked on 1
14 <blank Stuff I worked on 0.5
15 <blank Stuff I worked on 2
16 Thu, Mar-08-2009 <blank
17 Fri, Mar-09-2009 Stuff I worked on 3
18 <blank Stuff I worked on 2
19 Sat, Mar-10-2009 <blank
20 Sun, Mar-11-2009 <blank