Duplicate Rows with certain end date needs to show all rows, HELP

[mragans23]

I have an excel report that I need to create a new formula for and I am not sure it can happen.
I need a row to show
IF employeeid(row d) has multiple rows and one of those rows has an end date of 60 days from today, mark all rows as Review.

so for more information on this:
We have thousands of employees and some have one funding row with a 01/01/9999 end date and those do not need to be reviewed.
While we have some with multiples rows (could be 3 rows or 6 rows) and these people can also have one of their multiple funding row with an end date of 01/01/9999. but their other rows is what I am concerned with. IF one of their other rows shows an end date within the next 60 days, I need ALL of their rows (including the 01/01/9999 row) to pull in.
For example:

Employee Name	EmployeeID	Funding Begin Date	Funding End Date	Review
Bob Thorp	12345	12/10/19	05/15/20	Review
Bob Thorp	12345	12/10/19	05/15/20	Review
Bob Thorp	12345	5/15/20	01/01/9999	and I need this one to show review as well
Tim Heart	99112	12/01/19	09/20/20	NONE of these should show Review
Tim Heart	99112	12/01/19	09/20/20	NONE of these should show Review
Tim Heart	99112	09/21/20	01/01/9999	NONE of these should show Review
Mary Porter	33441	07/01/19	01/01/9999	This one should not show

HELP

Thank You,

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(COUNTIFS($A$2:$A$8,A2,$D$2:$D$8,"<"&TODAY()+60)>0, "Review","")

 

[mragans23]

Thank you so much. You are amazing.

 

[Fluff]

You're welcome & thanks for the feedback