I want to use this week.

Does "this week" run from Monday to Sunday?


--
Biff
Microsoft Excel MVP


"GEM" wrote in message
...
How can I sum a range of cells, identifing them by week.

For example, I have column B with dates, and colum C has different
numbers.
I want to use a SUMIF function on A1 that automatically adds different
cells
from column C which are included in this week.

Something like this, =SUMIF(B1:B100,TODAY(),C1:C100) but
instead
of TODAY(), I want to use this week.