If the date is in C1 and the columns are A and B of sheets 1,2 and 3
try:

=INDEX(FREQUENCY(Sheet1:Sheet3!A:B,C1-{1;0}),2)



lee wrote:
please help!!!

how can I set up a formula to count the frequency of a date from several
colums and from 3 work sheets???