FREE TRAINING CALENDAR IN EXCEL

Having a dynamic training calendar is a MUST for all HR professionals.

How it Works:

Type the below formula on the Calendar sheet.

=IFERROR(
TEXT(
INDEX(trainings[[Date From]:[Date From]],
     MATCH(TRUE,(NOT(ISBLANK(trainings[[Date From]:[Date From]]))($A6=trainings[[Training Title]:[Training Title]])MONTH(trainings[[Date From]:[Date From]])=MONTH(B$3)),0)),"mmm dd")
&" to "&
TEXT(INDEX(trainings[[Date To]:[Date To]],MATCH(TRUE,(($A6=trainings[[Training Title]:[Training Title]])MONTH(trainings[[Date From]:[Date From]])=MONTH(B$3)),0)),"mmm dd") 
&" Staff: "& 
INDEX(trainings[[Department]:[Department]],MATCH(TRUE,(($A6=trainings[[Training Title]:[Training Title]])MONTH(trainings[[Date From]:[Date From]])=MONTH(B$3)),0)),
"")

There are 3 INDEX & MATCH formulas that retrieve the start date, end date, and department being trained from the TRAINING Worksheet

Format the retrieved dates using the TEXT Function

To handle returned errors, wrap the whole function with the IFERROR function.

DOWNLOAD THE CALENDAR