A question I get asked a lot on this website is about how to create expiry dates for different courses in Excel.

So here is a video that shows you how to do it.

It does require that you have a list of courses with their duration in days e.g. a course with an expiry date of 2 years should be referenced as 720 (365 X 2) and you also need the date of the last course but you can use the ever, well, usually fairly, reliable, Vlookup for it.

Here’s the video

 

that shows you how to do it and you can download the completed file here.