today function returning incorrect date in some cells

Copper Contributor

i cannot figure out why the today function will not work in cell A1 or B1 . is that a thing?

 

=today()  works in the other cells.

 

anyone experience this?

 

date function.png

1 Reply

But there is no =TODAY() in formula bar for A1, how do you type it?