Weekly Staticitics - formular

[Sue Arlett]

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?

 

[Billy Liddel]

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

 

[joeu2004]

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.