try this one
you might have to use the datedif function on a different column and then use the count on that column.
Thanks thats a step forward but its not quite what I need:
I need to count the number of a certain type of phone call on this log - easy.... Countif(e2:e200,"Call closed")
Hard bit I need to only count them if they happened this week...
How do I include datedif argument in with this?
i think the easiest way to do that is to create a new column of everything that meets the criteria
ie if the date is in A and call closed or not is in B
create a column C Iff(datedif(today,A,7),B,0)
then do countif(c,"closed call")
Thanks for the help I managed to get it working using this for your info in future: