I have a list in column A of dates for every event day (e.g. the 2., 3., 10., 13., and 14. of febuary 2013) and in column B i would very much like a formula to count the number of event days, but only for the last 7 days. In other words, i need to read out the pace over the last 7 days in terms of events/week. I cannot get COUNTIF to have a variabel cell as criteria. Can you help?