Hi ,

I am Newbie to excel formulaes. I was trying to write one for calculating the number of high and low priority issues from a column say "G" and for a particular week(displayed in column D which has date that issue was created). The problem in my case is that the data changes weekly. I tried to use this formula which calculates the same for a specified week(feb 2nd week in this case). I want to make it generic. I tried using weeknum function along with countif but did not work. Any suggestions ?

=COUNTIFS(D:D,"=2/6/2011<=2/12/2011",G:G,"High")

-
Thanks
Ram