i am using a code for timestamp

The hours, minutes and seconds are expressed as a fraction of a day:

So, as suggested you should keep the INT part or ROUNDDOWN the value of the TIMESTAMP in order to match TODAY's date (that is an integer without decimals):

=INT($A1)=TODAY()
=ROUNDDOWN($A1)=TODAY()

CodePudding user response：

try:

=($A1*1<=TODAY() 1)*($A1*1>TODAY()-1)

or:

=INT($A1)=TODAY()

and see: https://stackoverflow.com/a/66201717/5632629

timestamp upon range edit:

=LAMBDA(x; x)(IFERROR(B1:1/0) NOW())