I have an excel file that holds records of certificates and their renewal dates.
I would like automate to check the excel file “Cert Expires” column that holds the expiry date, and take off 90 days to give a date range that the person needs to renew their training, and send an email to only those who are within the 90 days or less range.
For example – Certificate expires on 22/6/24 which is 67 days away from todays date (16/4/24). I want Automate to check the date, take off 90 days, and email only these people.
How do I go about this? I’ve tried many ways but keep getting errors.

Report
All responses (
Answers (