Excel. Fun One. When is an Employee Review due?

Employee 1. Hired 05/28/2014.
Employee 2. Hired 11/17/2014.
Employee 3. Hired 03/15/2015.

What formula can be used to return the words "Review Due" in a cell, that appears if today's date is 14 days (or less) before the Review date, OR 14 days (or less), after the Review date has passed?

Reviews are to be conducted every 90 day after the employee Hire date.

Thanks!
Cactus1993OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Maybe this....

Assuming
A2 = Employee
B2 = Hired Date

Then try this...
=IF(TODAY()>B2+90-14,"Review Due","")

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Matthew RichardsonProduct CoordinatorCommented:
This will work...I assumed you wanted 90 working days

With the employee name in A2 and the hire date in B2

C2 would be:
=IF(AND(TODAY()-WORKDAY.INTL(B2,90,2)>-14,TODAY()-WORKDAY.INTL(B2,90,2)<14),"Review Due","")

Open in new window


If you just want 90 regular days...C2 would be:
=IF(AND(TODAY()-(B6+90)>-14,TODAY()-(B6+90)<14),"Review Due","")

Open in new window

0
Steven CarnahanNetwork ManagerCommented:
So you want Employee 1 to reflect the review due every 14 days before or after each 90 days after their hire date?

Example:  Hired on 5/28/2014 so the cell would show review due during the following time periods:

5/14/2014 - 6/11/2014
8/12/2014 - 9/9/2014
11/10/2014 - 12/8/2014
etc.
0
aikimarkCommented:
Please confirm that this is the expected message given the first hire date and today's date:
HireDt  	TodayDt 	Msg
5/28/2014	9/5/2015	
5/28/2014	9/4/2015	Review Due: 8/21/2015
5/28/2014	9/3/2015	Review Due: 8/21/2015
5/28/2014	9/2/2015	Review Due: 8/21/2015
5/28/2014	8/7/2015	Review Due: 8/21/2015
5/28/2014	8/6/2015	

Open in new window

0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.