Hi,  I have inherited a spreadsheet of employees who have been on various courses based on their roles, the courses either have a 12 month, 2 year or 3 year expiry date, they are ordered in their relevant columns.  the dates are past dates and i need to add a formula so i can see when each person is 60 days out from needing to renew their course (amber) is over the due date (red) and the rest can be green, this gives me enough time to book the ambers in with pleny of notice and shows the current expired courses to prioritise.  i think i can use the TODAY() formula but as each date field is a historic date  i need to work off each individual field to give that persons due dates as they have gone on courses at different dates from each other. currently it is a nightmare tyring to keep track and i need a simpler visual que.   any help would be great.   thank you.