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 ?