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"

[TABLE="width: 255"]
<tbody>[TR]
[TD]Info[/TD]
[TD]Answer[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cisco[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Vtech[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Blank Rows[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 300"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Date[/TD]
[TD]Task[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD][/TD]
[TD]Check PBX[/TD]
[/TR]
[TR]
[TD]polycom[/TD]
[TD="align: right"]11/22/2017[/TD]
[TD]Time for a snack[/TD]
[/TR]
[TR]
[TD]polycom[/TD]
[TD="align: right"]5/15/2017[/TD]
[TD]Inventory count[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD="align: right"]5/16/2017[/TD]
[TD]Meet with Dev[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD][/TD]
[TD]Check PBX[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD="align: right"]5/24/2017[/TD]
[TD]Reset system[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD="align: right"]5/16/2017[/TD]
[TD]Meet with Dev[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD="align: right"]11/22/2017[/TD]
[TD]Time for a snack[/TD]
[/TR]
[TR]
[TD]Polycom[/TD]
[TD="align: right"]5/24/2017[/TD]
[TD]Reset system[/TD]
[/TR]
[TR]
[TD]polycom[/TD]
[TD][/TD]
[TD]Travel to Canada[/TD]
[/TR]
[TR]
[TD]cisco[/TD]
[TD="align: right"]6/20/2017[/TD]
[TD]Travel to Mexico[/TD]
[/TR]
[TR]
[TD]Cisco[/TD]
[TD="align: right"]11/22/2017[/TD]
[TD]Travel to Brazil[/TD]
[/TR]
[TR]
[TD]Cisco[/TD]
[TD="align: right"]6/20/2017[/TD]
[TD]Call partner[/TD]
[/TR]
[TR]
[TD]cisco[/TD]
[TD][/TD]
[TD]Visit with Cisco[/TD]
[/TR]
[TR]
[TD]Cisco[/TD]
[TD="align: right"]6/20/2017[/TD]
[TD]Call partner[/TD]
[/TR]
[TR]
[TD]Cisco[/TD]
[TD="align: right"]6/12/2017[/TD]
[TD]Dept goals due[/TD]
[/TR]
[TR]
[TD]Vtech[/TD]
[TD="align: right"]11/22/2017[/TD]
[TD]Dept training[/TD]
[/TR]
[TR]
[TD]Vtech[/TD]
[TD="align: right"]4/20/2017[/TD]
[TD]Training with SMB[/TD]
[/TR]
[TR]
[TD]Vtech[/TD]
[TD="align: right"]4/20/2017[/TD]
[TD]Training with SMB[/TD]
[/TR]
[TR]
[TD]Vtech.[/TD]
[TD][/TD]
[TD]The weekend is here[/TD]
[/TR]
</tbody>[/TABLE]

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...