Hi,
I work in the HR field and am aiming to improve my tracking of information for my candidates. Here I will attach an example of what my excel tracking document looks like for better context.
If you go to the right, you'll see there is a Medical column and to the furthest right is a start date column. Basically, what I'd like to do, is to be able to receive a warning message, or SOME form of warning, should the dates in the medical field and the start date be too close together.
For example, if someone has a medical checkup booked on January 17, but their start date on the furthest column is January 22nd, this is not enough time to receive the results and identify if they are healthy to start work as the reports for the clinic can sometimes take up to 8 business days to arrive.
Is there some way to do this? Ideally, it would be great to get this warning message or pop-up should the start date be 8 business days or less from the medical booking date, however I'm not sure if that's even possible to do on excel. If business days cannot be used, then I guess a simple 8 regular calendar days can work as well.. Or whatever you suggest.
Thank you!
Bookmarks