Hello, need help with excel formula, basically I have two worksheets, 1
woorksheet will have events with a specfic date and another worksheet which
summerises the events by a date range e.g
worksheet 1 worksheet 2
column A Column B column A column B
Wet 04/01/2010 w/c 04/01/2010 2
Cold 06/01/2010 w/c 11/01/2010 1
Hot 12/01/2010

At present the results would show in worksheet 2 as above, which I can input
manually but would like a formula to link the worksheets, by a formula which
counts up the events in worksheet 1 by specific dates e.g 04/01/2010
-10/01/2010 e.g weekly? Hope you can help