Recent content by mattagain

thanks guys, i have managed to get this working now, I found a formula for calculating week numbers =1+INT((A1-DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,5)+WEEKDAY(DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,3)))/7) one again thanks to all involved

i have looked at doing this by running a lookup from the date field, but i dont know how to calculate the weeknum automatically, i could do it manually, however, it would mean having to re-calculate it all each time a new spreadhseet was started

thanks for the help so far, i have run into a further problem i dont have access to the weeknum function, (our it dept have mislaid the excel discs, is there anyway to do this without it?

I am trying to create a short report from a list of data, I need to be able to quickly show weekly averages based on a specific team (i.e. if team=team1 and date is between start and end dates) on my data sheet i have the following headings :- Date / Agent / Team / Type Of Call / Quality Score...