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]

Try this

Cell A1: 10/01/2020 23:30:00

=IF(VALUE(A1)>VALUE(NOW()), "Not passed", "Passed")

 

[AtTcQ]

Try this

Cell A1: 10/01/2020 23:30:00

=IF(VALUE(A1)>VALUE(NOW()), "Not passed", "Passed")

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

 

[MARK858]

One way...

Book1
	A	B	C
1	04/12/2020 14:41:00		Not passed
2	04/12/2020 14:39:00		Passed
Sheet3

Cell Formulas
Range	Formula
C1:C2	C1	=IF(A1>=(DATEVALUE("04/12/2020")+TIMEVALUE("14:40")), "Not passed", "Passed")

 

[AtTcQ]

Can i still use the TODAY function without actually putting a date in?

Tried this but its saying "Passed"
=IF(D:D>TODAY()+TIMEVALUE("22:00"),"Not passed", "Passed" )

 

[MARK858]

Can i still use the TODAY function without actually putting a date in?

You can't use it for an entire column like that, best describe exactly what you are trying to achieve.

 

[AtTcQ]

Even when i set it to the selected column it still doesnt work

 

[AtTcQ]

I meant row*

 

[MARK858]

I meant row*

Post a sample of your data using the board XL2BB app and describe exactly what you are trying to do.
Post number 4 was directly from the worksheet and as I stated you can't apply it to an entire column which is what D:D is.

 

[AtTcQ]

Can i upload the excel file?