Fill the cel_# with the cell reference.
Formula:
=IF(AND(DATE(YEAR(cel_1),MONTH(cel_1),DAY(cel_1))<cel_3,TIME(HOUR(cel_2),MINUTE(cel_2),SECOND(cel_2))<cel_3),"Msg1","Msg1")
Fill the cel_# with the cell reference.
Formula:
=IF(AND(DATE(YEAR(cel_1),MONTH(cel_1),DAY(cel_1))<cel_3,TIME(HOUR(cel_2),MINUTE(cel_2),SECOND(cel_2))<cel_3),"Msg1","Msg1")
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