This is my first post, so be patient with me.
I currently have a workbook containing a worksheet for each employee, and a table in each one including: a list of procedures that each employee must be tested on, the date the the testing was completed, and the date that the employee must be tested again.
In each worksheet, I have used a date function to add 5 years to the completed date, to create the due date.
Then, in the due date column, I have used conditional formatting to change the color of the cell to yellow and red if the due date is within six months and has already passed, respectively.
On a separate worksheet, I have a list of the employee names. I have used an if function and sum function to get a column to state "update required" if the due date is within six months, or already passed.
Is there any way to also get excel to report the procedure number and due date of the expired procedure in this worksheet?
Somehow, I'd like to summarize on one separate worksheet if any updates are required, and if so, which procedures require updates by what time.
I currently have a workbook containing a worksheet for each employee, and a table in each one including: a list of procedures that each employee must be tested on, the date the the testing was completed, and the date that the employee must be tested again.
In each worksheet, I have used a date function to add 5 years to the completed date, to create the due date.
Then, in the due date column, I have used conditional formatting to change the color of the cell to yellow and red if the due date is within six months and has already passed, respectively.
On a separate worksheet, I have a list of the employee names. I have used an if function and sum function to get a column to state "update required" if the due date is within six months, or already passed.
Is there any way to also get excel to report the procedure number and due date of the expired procedure in this worksheet?
Somehow, I'd like to summarize on one separate worksheet if any updates are required, and if so, which procedures require updates by what time.