The help provided so far has been much appreciated.
Now I need to add a feature.
Here's the file.
monthly avg of duration.xlsx
The data consists of a START date and END date.
Column C is END date minus START date, or, the DURATION of the event (in days).
I need to list the average duration for each month based on the ending month.
For example -
For Jan, only one event ended and it took 8 days so the average would be 8 days.
For Feb and Mar however, no events ended so the avg would be 0.
To continue for clarity,
3 events ended in April...