Hi there,

I'm having problems with the if-function in Excel 2003.

This is the case:

I have a sheet with dates on which assignments were executed.
Now I want to count them by week.

from 1-1-2012 untill 1-7-2012 -> 32 assigments were executed (so 32 different dates in column within the range 1-1-2012 / 7-2012)
from 1-1-2012 untill 1-7-2012 -> 28 assigments were executed (so 28 different dates in column within the range 8-1-2012 /14-2012)
etc.


Does anyone have a clue?
thnx
Val.