Originally Posted By: tanstaafl.
Originally Posted By: petteri
candidate is eligible for a position as long as they have 6 months experience from hire date.

If I understand you correctly, you are looking to "green-light" employees who have been working for you for six months or more, with the current "today" date being the reference point.

The attached sample spreadsheet will do that, if the hire dates for the employees are in the same column.

You will want to look in "Conditional Formatting" to see how this works.

tanstaafl.


Thanks! It won't be from "today" but from position posting date vs hire date. I've been playing around with the DATEDIF formula and I think I might have a solution.

I've looked into conditional formatting and have found a few things there that I can use with the DATEDIF formula. Attached my file. Yes it's a mess I'll need to tidy it up! blush


Attachments
interview schedule 2017 - sample.xlsx (35 downloads)



Edited by petteri (06/11/2017 17:57)