Not so easy to do in excel. It is difficult to record historic training if you want it to remind you of when next due. I have one where you have names in column "A" say then subsequent columns list a each type of training ( taking up two columns for each type. These two columns have the last done date in the first one and then a calculation of when the next is due in the second. The frequency is in the row just under the training type. so the formula looks on row12 column M looks like " =IF(L12="R",0,IF(L12>=1,L12+(L$7*365),"")) If the manager types R in the last done column (column L above) it means it is required and so puts "0" in column M otherwise if there is no date it also puts nothing, if however there is a last done date it adds the number of years in cell L7 (times 365) to the last date, to give next due. Easy eh I then use conditional formatting to compare the next due date against today's date ( as opened ) ie the formula is "=TODAY()" it then colours the due date with different colours, depending on due next month, this month or late. Ie the formula for next month is =DATE(YEAR(C2),MONTH(C2)+1,DAY(1)) Where I have the =Today() in C2 But as I say you type over the last done date when it is next done so no history. An access database would be easier, but I'm the only one in the company that can use it and I don't feel like creating or maintaining it. Enjoy Chris