Checking Expiration Dates through Formula, through Conditional Formating and through VBA
At times you want to be able to check if a particular date is past a certain date or going to be past a certain date. This video shows you how to do that exactly.
In this video we check the expiration dates of credit cards against today's date (24th of March 2017) or within the next 3 days of today. We do this via a simple IF OR statement, then we do it via conditional formatting and then we write a small VBA code to accomplish this.
The excel file has been uploaded on the Watch Learn Grow Repeat group on Facebook. The link to the file is:
/ 515676552153394
If you liked this video then please give it a thumbs up and if you would like to see more videos like this then please kindly subscribe.