Need Help on this advanced formula

[Jarodjp42]

This is a three step problem, I would need one formula to do all 3 things! Can some please help and give me insight on this?

• If it is past 6:00 pm and a double digit day, count the unique times the item shows up in the Data sheet. The Item needs to be unique, have a unique date and task
• If it is past 6:00 pm and a single digit day, looking at the date provide the following tasks that need to be completed.
• If it is past 1:00 pm and a double digit day, Count the number of blank rows in the date column. When you get the correct answer, turn it to a word instead of a value so "TWO" instead of 2. Also, make the answer cell change to a blue fade from center format, and if its the wrong answer, make the format be Red with White text saying "Try Harder"

Info	Answer
Polycom
Cisco
Vtech
Task 1
Task 2
Task 3
Task 4
Blank Rows

<tbody>
</tbody>

Item	Date	Task
Polycom		Check PBX
polycom	11/22/2017	Time for a snack
polycom	5/15/2017	Inventory count
Polycom	5/16/2017	Meet with Dev
Polycom		Check PBX
Polycom	5/24/2017	Reset system
Polycom	5/16/2017	Meet with Dev
Polycom	11/22/2017	Time for a snack
Polycom	5/24/2017	Reset system
polycom		Travel to Canada
cisco	6/20/2017	Travel to Mexico
Cisco	11/22/2017	Travel to Brazil
Cisco	6/20/2017	Call partner
cisco		Visit with Cisco
Cisco	6/20/2017	Call partner
Cisco	6/12/2017	Dept goals due
Vtech	11/22/2017	Dept training
Vtech	4/20/2017	Training with SMB
Vtech	4/20/2017	Training with SMB
Vtech.		The weekend is here

<tbody>
</tbody>

I don't even know where to begin, but would love to know how to write a formula that would work to bring the correct information back. Thanks if you can help!!

 

[Truiz]

What should be the answers for your example, I'm having trouble understanding what should be displayed in the answer column

 

[Jarodjp42]

In the answer column it is suppose to be a number. It is counting how many times Polycom shows up with a different date and task. so for Polycom the answer should be 6, cisco should be 5, Vtech should be 3.

 

[Jarodjp42]

Not exactly sure what they want in the task answer boxes. Sorry...