I am trying to create a functional spreadsheet for an HR department. There are several background checks that must be renewed each year, some every two years and others every 3 & 5 years.
In cell A1 is the date in which the most recent search was completed. Then I would like the formula to go into the next cell of B1. I need a formula that will return with "Current", "Due", or "Over Due" so that we can create a slicer and make the spreadsheet more manageable overall.
I'm not sure if that makes any sense or not.
In cell A1 is the date in which the most recent search was completed. Then I would like the formula to go into the next cell of B1. I need a formula that will return with "Current", "Due", or "Over Due" so that we can create a slicer and make the spreadsheet more manageable overall.
I'm not sure if that makes any sense or not.