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