I have a table with several dates Date_1 Date_2... date_52  I need a fromula that lets me calculate the number of occurances if any of these  dates fall into a range selected by the user.( upper date and a lower date). Example user selects the dates 6/12/07 to 8/12/07, how many occurances in this range are present in my date table? if this range matched dates in  Date_1 date_2... Date_40. I would like to return 40 in this instance.

Oh yeah - you could create your own function called like "IsInDateRange()" and pass it the date field. That way you only need one formula written. You could do:

IsInDateRange(d1) + IsInDateRange(d2)+...+IsInDateRange(d52)