As many of you know, I work in a team that delivers IT training courses. Last week I was creating my course schedule for April. I used Excel to draw up the schedule before entering the information into our course booking system.
Why Excel? Well it gave me a visual overview as to what courses to schedule and when to schedule them. I needed to make sure that I scheduled enough of each course and not schedule 2 courses at the same time. Here’s just part of the spreadsheet:
My boss then wanted to know how many of each course I scheduled. I used a formula in J2 (which I then copied down to J3:J6). The formula is:
Which means count the number of cells in the range B2:I2 where the cell contains a date that is on or after 13th April 2015 (I’m on vacation until 13th April so my schedule begins on that day).
As I’m based in the UK, I used the DD-MM-YY format but if you are based elsewhere, just change the date format in the formula.