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

[fvplayer src=”https://s3-eu-west-1.amazonaws.com/the-excel-expert/Renewal_dates.mp4″]


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