Formula:
=IF((DATE(YEAR(M2),MONTH(M2),DAY(M2)))<(DATE(YEAR(P2),MONTH(P2),DAY(P2))),"No",IF(AND(DATE(YEAR(M2),MONTH(M2),DAY(M2))=(DATE(YEAR(P2),MONTH(P2),DAY(P2))),(N2)<(TIME(HOUR(P2),MINUTE(P2),SECOND(P2)))),"No","Yes"))
Formula:
=IF((DATE(YEAR(M2),MONTH(M2),DAY(M2)))<(DATE(YEAR(P2),MONTH(P2),DAY(P2))),"No",IF(AND(DATE(YEAR(M2),MONTH(M2),DAY(M2))=(DATE(YEAR(P2),MONTH(P2),DAY(P2))),(N2)<(TIME(HOUR(P2),MINUTE(P2),SECOND(P2)))),"No","Yes"))
Have you got the result or not?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks