View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
hoyt
 
Posts: n/a
Default counting occasions dates occur between 2 dates

i have a column which shows the date that a task is complete, what i want is
a formula to show how many times the task has beem completed in a week. for
example if the column had the date 12/6/6 three times and the date 15/6/6,
seven times then between 12/6/6 & 18/6/6 the task has been completed ten
times.

is this possible, any ideas?

thanks