How to Track Expiry Date of items on Excel (Automated with VBA)

This is an Excel Template that will enable you track when items, products, papers, licenses, certificates expires and due for possible renewals. With this Template the following information can be generated: 1. Items/papers expiring/expired within the current week 2. Items/papers expiring within the next week 3. Items/papers expiring/expired within the current month 4. Items/papers expiring within the next month 5. Items/papers expiring/expired within the quarter 6. Items/papers expiring within the next quarter 7. Items/papers expiring/expired within the year 8. Archive expired items 9. Delete expired items 10. Track Renewal of items for different departments in your organization. There is a simple dashboard that shows you the following information: 1. Number of products within 90 days to expire 2. Number of tracked items in the system 3. Number of expired items 4. Number of items expired/expiring in the current year This Template can also be used to track Personal TASKS and get a summary of TASKS that have been achieved and those that are still pending. Beyond the features written here, the Templates can do much more. See the video tutorials and send us a message if you need the demo file. Send a message via the contact form in the Customized Template. We have some Free Templates that may be of benefits to you.