Try this one.

=IF(NOW()<=DATEVALUE(&month(e6)&"/"&DAY(E7)&"/"&year(e5),"",IF(A!E8=TRUE,"P","N"))
I noticed you used merged cells. I advice you not to work with that; it get you in trouble sooner or later.