• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Frequency of Dates within a certain week

s_k_s

New Member
Hi All,

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.

Thanks
 

Attachments

  • Book2.xls
    30 KB · Views: 9
Try this:

Code:
=COUNTIFS(Actual!$A$2:$A$65,">="&A2,Actual!$A$2:$A$65,"<="&B2)
In C2 (of sheet Target) place the formula and copy down
 
S_K_S,

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

=SUMPRODUCT((Actual!$A$2:$A$65>=Target!A2)*(Actual!$A$2:$A$65<=Target!B2))
 
Back
Top