IF function with dates and conditions

Hello, my manager gave me a project today with 10,000 rows of data due tomorrow. I'm not familiar enough with Excel to write the below IF function. I would prefer not to do this manually. Can I please get some assistance. Basically, I need to choose the oldest date and set conditions. This is my first time on the forum. Please see attachment.



if A2=C2, N
if C3 is "empty" choose W
if A6 is "empty" choose L
if C7 is "updating" choose W
if C4 is < A4 choose L
if A5 is < C5 choose W