Using Greater than and Less Than in formulas.

I’m using the following formula to work out dates. =IF(G2:G40=TODAY(),1). What i need is for the formula to tell me if yesterdays date shows up then the value to be 1 and if tomorrows date is in the cell then it to show false. Any advise?

Thanks
David