Home

today function returning incorrect date in some cells

%3CLINGO-SUB%20id%3D%22lingo-sub-364013%22%20slang%3D%22en-US%22%3Etoday%20function%20returning%20incorrect%20date%20in%20some%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364013%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20cannot%20figure%20out%20why%20the%20today%20function%20will%20not%20work%20in%20cell%20A1%20or%20B1%20.%20is%20that%20a%20thing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dtoday()%26nbsp%3B%20works%20in%20the%20other%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eanyone%20experience%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%3E%3CSPAN%20class%3D%22lia-message-image-wrapper%20lia-message-image-actions-narrow%20lia-message-image-actions-below%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86415iE2D00096A8F0D644%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20border%3D%220%22%20alt%3D%22date%20function.png%22%20title%3D%22date%20function.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364013%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364088%22%20slang%3D%22en-US%22%3ERe%3A%20today%20function%20returning%20incorrect%20date%20in%20some%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364088%22%20slang%3D%22en-US%22%3E%3CP%3EBut%20there%20is%20no%20%3DTODAY()%20in%20formula%20bar%20for%20A1%2C%20how%20do%20you%20type%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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