I have a column listing dates as MM/DD/YY. I need to break down the dates by month.
For instance, if there are 5 dates showing 12/31/04, then I need to find the formula that will show me the quantity 5 for the month of December regardless of the day. If there is only one date for the month of January, then how can I calculate there is only one date in January? Does this make sense?