Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Evaluation Date (XP)

    I would like to see words like "due now" - or whatever - in the Eval Due column when the month in Column D matches the current month. Every employee must be evaluated in the month they were originally hired - every year.

    Thanks again

    aunt linda

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Evaluation Date (XP)

    Hi Linda

    Try this:
    <code>=IF(MONTH(D2)=MONTH(TODAY()),"Due now","Not due")</code>

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Evaluation Date (XP)

    Thank you, thank you. I'd like to think if I had devoted some time to this problem I could have solved it myself - but you have saved me, probably, a few months of straining the gray matter.

    Works like a charm

    Again

    Thanks


    Linda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •