Quote:
Originally Posted by justkar4u
And by the way it D to D and not grin !
|
Insert a column for the
WEEKNUM function.
In this example, let's say
Column E has the
WEEKNUM for the dates of
Column D:
=
SUMPRODUCT(--(E:E=7),--(E:E<=9),--(G:G="High"))
Whe
7 is the WEEKNUM for 02/06/2011
9 is the WEEKNUM for 02/12/2011