On the Target tab I need to count the number of times dates occur within a week on the Actual tab. Should be a straight forward COUNTIF but I can't seem to get it right so your help would be appreciated.
Enter the below into your targets column and copy down, if you're using later than excel 2003 then you can also use the countifs function but i'm restricted at work to 2003 so can't test the syntax for it