IF DATE and TIME

[AtTcQ]

I currently use this to check if date has passed but i also need to set a time on it too. Is it possible?

=IF(B:B>TODAY(),"Not Passed","Passed")

 

[juddaaaa]

I'm sure this is what you're after

=IF((B1+C1)<NOW(),"PASSED","NOT PASSED")

Book1
	A	B	C	D	E	F
1	EVENT 1	10/01/2020	12:00:00 AM	PASSED
2	EVENT 2	10/01/2020	11:00:00 PM	PASSED
3	EVENT 3	10/01/2020	1:00:00 AM	PASSED
4	EVENT 4	10/01/2020	10:00:00 PM	PASSED
5	EVENT 5	10/01/2020	2:00:00 AM	PASSED
6	EVENT 6	10/01/2020	9:00:00 PM	PASSED
7	EVENT 7	10/01/2020	3:00:00 AM	PASSED
8	EVENT 8	10/01/2020	8:00:00 PM	PASSED
9	EVENT 9	10/01/2020	4:00:00 AM	PASSED
10	EVENT 10	10/01/2020	7:00:00 PM	PASSED
11	EVENT 11	10/01/2020	5:00:00 AM	PASSED
12	EVENT 12	10/01/2020	6:00:00 PM	PASSED
13	EVENT 13	10/01/2020	6:00:00 AM	PASSED
14
15	EVENT 14	11/01/2020	12:00:00 AM	PASSED
16	EVENT 15	11/01/2020	11:00:00 PM	NOT PASSED
17	EVENT 16	11/01/2020	1:00:00 AM	PASSED	TIMEVALUE	CURRENT TIMEDATE 11/01/2020 12:45 PM
18	EVENT 17	11/01/2020	10:00:00 PM	NOT PASSED
19	EVENT 18	11/01/2020	2:00:00 AM	PASSED
20	EVENT 19	11/01/2020	9:00:00 PM	NOT PASSED
21	EVENT 20	11/01/2020	3:00:00 AM	PASSED
22	EVENT 21	11/01/2020	8:00:00 PM	NOT PASSED
23	EVENT 22	11/01/2020	4:00:00 AM	PASSED
24	EVENT 23	11/01/2020	7:00:00 PM	NOT PASSED
25	EVENT 24	11/01/2020	5:00:00 AM	PASSED
26	EVENT 25	11/01/2020	6:00:00 PM	NOT PASSED
27	EVENT 26	11/01/2020	6:00:00 AM	PASSED
28
29	EVENT 27	12/01/2020	12:00:00 AM	NOT PASSED
30	EVENT 28	12/01/2020	11:00:00 PM	NOT PASSED
31	EVENT 29	12/01/2020	1:00:00 AM	NOT PASSED
32	EVENT 30	12/01/2020	10:00:00 PM	NOT PASSED
33	EVENT 31	12/01/2020	2:00:00 AM	NOT PASSED
34	EVENT 32	12/01/2020	9:00:00 PM	NOT PASSED
35	EVENT 33	12/01/2020	3:00:00 AM	NOT PASSED
36	EVENT 34	12/01/2020	8:00:00 PM	NOT PASSED
37	EVENT 35	12/01/2020	4:00:00 AM	NOT PASSED
38	EVENT 36	12/01/2020	7:00:00 PM	NOT PASSED
39	EVENT 37	12/01/2020	5:00:00 AM	NOT PASSED
40	EVENT 38	12/01/2020	6:00:00 PM	NOT PASSED
41	EVENT 39	12/01/2020	6:00:00 AM	NOT PASSED
Sheet1

Cell Formulas
Range	Formula
D1:D13, D29:D41, D15:D27	D1	=IF((B1+C1)<NOW(),"PASSED","NOT PASSED")
F17	F17	="CURRENT TIMEDATE " & TEXT(NOW(), "DD/MM/YYYY HH:MM AM/PM")

 

[AtTcQ]

I dont need the time on it i just want to check if its passed that time and date or not e.g put the time in function

 

[AtTcQ]

That works though thanks! juddaaaa

 

[MARK858]

That works though thanks! juddaaaa

So the below way back in post number 3 was incorrect?

Sorry i forgot to mention i want to add a specific time not the current time e.g 23:00