IF Cell = Today THEN 1 ELSE = 0

[GreenWizard]

Is there a formula for determining if a Date & Time is TODAY? For example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]TIME[/TD]
[TD]TODAY[/TD]
[/TR]
[TR]
[TD]12/13/2018 4:02 AM[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]12/12/2018 8:31 PM[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12/15/2018 1:02 PM[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12/13/2018 5:17 PM[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Please note the 'TODAY' column. I'm looking for a logic formula that can tell me if it's today or not (1 = YES, 0 = NO).
I've tried using this formula, but it doesn't work >>> =IF(A1=TODAY(),1,0)

Thank you!!!

p.s. The current day for this forum post is 12/13/2018

 

[sandy666]

maybe A2 not A1 because in this table A1=TIME

 

[sandy666]

....
and NOW() instead of TODAY() because TODAY() doesn't contain time

two ways:
=IF(A2=NOW(),1,0)
or
=IF(DATE(YEAR(A2),MONTH(A2),DAY(A2))=TODAY(),1,0)

 

[jtakw]

Hi,

How about:

Book1
	A	B
1	TIME	TODAY
2	12/13/2018 4:02	1
3	12/12/2018 20:31	0
4	12/15/2018 13:02	0
5	12/13/2018 17:17	1
Sheet399

Cell Formulas
Range	Formula
B2	=--(INT(A2)=TODAY())

 

[eduzs]

Try:
=IF(DATEVALUE(TEXT(A2,"d/m/yyyy"))=TODAY(),1,0)

 

[cooper645]

I used the following in B1; ="TODAY is "&TEXT(TODAY(),"dd/mm/yyyy")

which uses the volatile today() function only once

and then in B2 I used; =IF(TEXT(LEFT(A2,10),"dd/mm/yyyy")=RIGHT($B$1,10),1,0)

This should reduce the number of times the TODAY() function is on your sheet, which I believe is more efficient.




or you could have a cleaner look:

B1; =TEXT(TODAY(),"dd/mm/yyyy")

B2; =IF(TEXT(LEFT(A2,10),"dd/mm/yyyy")=$B$1,1,0)