Thank you for your reply NBVC I am nearly there but I don't think I explained it well. basically if column A2 has a set of dates from Jan to Jun this year where test have been taken, I would like column B2 to let me know after 5 months that it was up for renewal and then C2 to notify me after 11 Months and finally D2 after 23 Months. This is because the test expire at different times for different users. I hope this makes it clearer!
|