I have a form that states in 1 row a total number of hours a person
worked on a day.  Above this row i have a row where i place the date of
the certain day this person worked these hours( with TODAY()).

example:
Date:                   21-5-2006       23-5-2006     25-5-2006
hours worked daily:      3  ,               5 ,                4,    

WHat i want is that iwant to generate the total number of hours a
person worked weekly.
I want to generate this from the dates.

In short   i want excell to look at these dates   (for instance:
21-5-2006, 23-5-2006, 25-5-2006.   ANd take these dates   beginning
from monday to calculate a week   and than add the numbers  that i
place next to the hours worked a day row   and add them up    getting
an hours worked a week total on the bottom.

Total number of hours worked this week:    (if 21-5-2006  is monday
than this number should be: 12)

And i want these number to change every week    when a new week is
beginning.    

Can anyone point me in the right direction to work this out ?