Date Reminder is for recurring or nonrecurring events, like birthdays, bills to pay, or appointments. The date reminder can be run from the Startup folder with an option to show only if there is.
What is aladdinPRO?
aladdinPRO is a free expiry reminder app that can keep track of your renewals.
How does it work?
Once set up, aladdinPRO will remind you through email, mobile and desktop notifications.
How do I set up?![]()
Scroll down and sign up for a free account. We'll guide you through rest of the process.
“We use it to keep track of employee documents. I should say I have never seen something so useful in my whole career. Especially in the middle east with a lot of documents to keep track of per employee, this is something really useful.”
“We, the IT department has always had issues with renewal of software licenses, domain names, service contracts etc. With aladdinpro we have it all under one roof and I can keep track of them with their mobile app and I get email and desktop notifications too.”
“I have been looking for something to keep track of the family's personal documents. With aladdinPRO I can keep soft copies of visas, passports, id cards, medical insurances etc online. Everything is so easily accessible on the go with their android app and the best part is, it reminds me when something is due for renewal.”
Do you use Excel to keep track of software subscriptions, or domain registrations, or other things with an expiry date? It's important to keep track of those dates, so here's an example of how to monitor expiry dates in Excel, and see what needs to be renewed soon.
Expiry Dates List
Here's a simple list of expiry dates for Microsoft Office subscriptions. Those have to be renewed every year, so that you don't arrive at the office one day, and find out that you can't use Excel. Oh, the horror!
How Many Days to Expiry Date
To make it easy to see which subscriptions are expiring soon, I'll use conditional formatting to highlight anything that will expire within the next 30 days.
I could make a conditional formatting rule that is based on the Expiry Date column, but I find it easier to check regular numbers, instead of dates.
So, I'll add a new column, with a formula to calculate the number of days there are before the expiry date. In the screen shot below, you can see that new column – DaysToExpiry.
The formula in that column F subtracts the current date from the Expiry Date: =D3-TODAY()
The results look a bit strange though, when you hit the Enter key, to add that formula.
Fix the Results
Because the formula refers to a date cell, Excel 'helps' us, by formatting the result as a date too.
A couple of the rows have expiry dates in the past, and those rows show number signs in the DaysToExpiry column. Excel can't convert negative numbers to dates, so it shows those number signs instead.
To fix all the results:
Expiry Date Reminder Software Free TrialHighlight Upcoming Expiry Dates
To make the upcoming expiry dates stand out, we'll use conditional formatting. Based on the result in the DaysToExpiry column, we can highlight the expiry dates which are 30 days (or less) from today.
To add the conditional formatting:
The table rows with upcoming expiry dates are highlighted with the colour that you selected.
More Expiry Date Warnings
With conditional formatting on the expiry date list, you'll quickly see which subscriptions need to be renewed soon. Just open the workbook every day, and renew those subscriptions, as soon as they're highlighted. Then, remember to change the Expiry Date, so you'll get a warning next year too.
Expiry Date Vs Expiration Date
If you want additional warnings, my sample file also shows how to make a hyperlink appear, in a SendEmail column. You could click that to send an email about the expiring subscription, if someone else is supposed to renew it. Or, have a link to the website where you go to renew the subscription.
Expiry Dates Summary
My sample file also has a Summary sheet -- it shows the total count of expiry dates, and the number that are expiring soon.
If you don't want to open the Expiry Dates workbook every day, you could link those summary cells to another workbook – one that you DO open every day.
Download the Sample File
Get the sample Excel file for this tutorial from my Contextures website. Go to the Excel Sample Files page, and in the Conditional Formatting section, look for CF0008 - Expiry Date Warning. The zipped file is in xlsx format, and does not contain any macros.
And while you're on the Sample Files page, take a look around. There are lots of other files there – you might find some other interesting techniques to try.
Expiry Date Reminder Software Free Full
________________________
________________________
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |