I have three columns A= Date of Record Entry , B = Event Date (Target Date) , C = Days Out from Target date
Objective : Based on columns A, B, and C : I want to be able to lable the data entry date in column A that match with the target date in column B as "Final" in a new calculated column in which will be our Column D.
Problem: The record date entry in ( Column A ) are manuel dates that have entries occuring past the target date in (column B). These rows are represented in the "Days out" ( column C ) as negative days out.
These negative values in (Column C) that correspond to a target date listed in "Event Date" (Column B)
Now contain the record or row of information we would like to label as the final date in the calculated colum D.
Question: What would be the best formula to construct a newly formed calculated column (column D) , that would seek entry dates (column A) matching the target dates (column B) unless it is the latest entry date entered ?
My attempt: I have played around with Switch(True() and If functions, also "&&" and "||" but unable to achieve my intended goal for calculating the new column D.
Please find the following attached workbook for reference.
Also, any contribution to finding a solution is highly appreciated and thank you for any assistance.