Here is a screen shot of what I have. For example the date Jan 1 2010 is equal to the serial number 40179 in Excel. How to calculate the relative frequency in Excel.
With the addition of the COUNTIFS function in Excel 2007 we now have an easier and more-powerful way to generate frequency distributions.
FREQUENCY always returns an array with one more item than the bins_array. Open your project in Excel. This is by design to catch any values greater than the largest interval in the bins_array. To delete this array formula select the range D4D9 and press Delete.