Most Common Range

Question

I am trying to determine the most common 4-year range in a list of dates. Is there a formula that I can use in Excel 2007 to find out this statistic?

Answer 1

COUNTIF and COUNTIFS can be used to count cells with dates, numbers, and text that match your specific criteria. The required arguments are Range (select the column(s)/row(s) where you want the program to search/look); and, Criteria (the from date and to date range sought). Assuming you have a column holding the various dates setup, he basic formula would be: =COUNTIFS(range,">="&date1,range,"<="&date2)