• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Employee Evaluation Schedule

K

kmakifl

Member
Hello, I would like to create a file that will calculate when employee evaluations are due and to have an "alert" when one is due or past due. Process is from hire date or promotion date, there is a 45day, then 90day, then 180days, and annual


Is there a formula in excel that help automate this process?

Thank you.
 
If you just mean you want it flagged then I suggest that you start by reading Chandoo's piece on conditional formatting with dates: http://chandoo.org/wp/2010/01/05/conditional-formatting-dates/


If you still need help after this, or are after something more complex e.g. auto-emails, then come back with some more detail about how you want this alert to work and we'll see what we can do.

Regards,
 
You must log in or register to reply here.
Back
Top