Hi folks

My aim is to show the totals as a percent, how long it takes people from applying for a course to attending .

I have a list of two dates:

An Application Date (the date contact is made to attend a training course) and the Course Date (the date of the course).

From a list of Course Dates in a given month, (in this example March 2019) I want to calculate the difference between the Application Date and the Course date, for each candidate in months and then group those totals by months and shown as a percentage.

At the moments I'm typing this manually and I'm looking for a formula that can work these numbers out automatically.

Instead of keep typing manually I was trying to use the CHOOSE formula to give the months in Column F but don't know how to select just one month consecutively from the list so maybe I'm going the wrong way with that ?

Any formula guru's out there able to assist?

1. Find the month of course dates from Column B Displayed in F8 - I used =TEXT(B2,"MMM") function.

2. Find how many course places there were for that month - =SUM(B:B) varies depending on data loaded into columns A and B

3. Group Column A by month and find totals for each month displayed in F, G - (I just count manually)

4. Calculate as a percentage of all course dates, each total for each month H - simple calc based on above)

5. Show totals for each month and as a percentage - as per sheet

Many thanks

Smudge