Hi,
I have a table of data that counts various items on a daily basis. The data
is arranged in a table -

Date - Item 1 - Item 2 - Item 3 etc

I need to count the total as each week progresses from that weeks Monday.
Can anyone advise on a formula to count each column total from the last
Monday (date) in the table?. The forumla would ned to find the Monday of the
current week and total the sum of each day of the current week.

Cheers,
Mickey