Auto Update data in a cell if it contains date less than today after 18:00 hrs using VBA.
Dear Forum,
I have a file where I store two dates for Insurance certification details of all employees in my organisation.
These certificates expire in three years, I have dates from past so many years which are nearing expiry, the moment the dates expire I change the date content to "Due for Renewal" for all employees who are still Active in the system , the Active Flag being stored in another column.
So, I was wondering if this could be done automatically on the Sheet Open event..for all the dates which are less than today after 18:00 hrs as the certificate is valid till 17th May i.e today then this should only impact or show as "Due for Renewal" after 18:00 HRS...
So, is this possible ?
Please can someone help me with the VBA code if the Issuance Date is in the column D and the Till Date is in the column E and the Active Flag is in the column F..
Warm Regards
e4excel
Bookmarks