=IF(WEEKDAY($A2)<1,"",SUM($C$1:$C2)-SUM($D$1:$D1))

BTW 1st Mar is a Sun according to my calendar.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Gregg" wrote in message
...
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