Show Expiry Dates Across Multiple Columns
It's always such a pain in the ass to sift through your data and be able to see whats expiring, what's due etc
A lot of our data may have multiple items that have various expiry dates. For example each person in has a car registration, license, third party, comprehensive (optional) insurance which may all have different expiry dates.
To be able to see if a person has any of these outstanding and seeing the whole picture we add an extra column called "DATA FILTER" which looks in the columns for each person and returns a 1 or 0 if there is a date that is less than the value we set at the top of the page.
Download example here: EXPIRY DATES MULTIPLE COLUMNS TEMPLATE.xlsm
I have also done some conditional formatting to easily display the expired dates.
To extend the formula to other columns simply do as below
