My boss wants me to give him weekly statistics of project works coming in and
ones which works which has been completed for each week of the month. is
there a formula for this?
--
Sue J Arlett

Sue,

Say in B1 you have the weeks start date, and in b2 the week end date. The
start Date is in A4:A400 and the finished dates are in B4:b400 then

New Orders for Week:
=SUMPRODUCT(--($A$4:$A$400=$B$1))-SUMPRODUCT(--($A$4:$A$400$A$2))

Completed orders for week:
=SUMPRODUCT(--($B$4:$B$200=$B$1))-SUMPRODUCT(--($B$4:$B$200$A$2))

This gives you one weeks stats. Replicate for N weeks and adjust the ranges
to suit.

Regards
Peter Atherton

"Sue Arlett" wrote:

My boss wants me to give him weekly statistics of project works coming in and
ones which works which has been completed for each week of the month. is
there a formula for this?
--
Sue J Arlett

On Feb 26, 5:16*pm, Sue Arlett
wrote:
My boss wants me to give him weekly statistics of
project works coming in and ones which works which
has been completed for each week of the month. is
there a formula for this? *

Yes.