Try this one.
I noticed you used merged cells. I advice you not to work with that; it get you in trouble sooner or later.![]()
=IF(NOW()<=DATEVALUE(&month(e6)&"/"&DAY(E7)&"/"&year(e5),"",IF(A!E8=TRUE,"P","N"))
Try this one.
I noticed you used merged cells. I advice you not to work with that; it get you in trouble sooner or later.![]()
=IF(NOW()<=DATEVALUE(&month(e6)&"/"&DAY(E7)&"/"&year(e5),"",IF(A!E8=TRUE,"P","N"))
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks