=Function() returning incorrect date in some cells

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
I'm sure you've checked the formatting?....as a work around couldn't you just create 2 new columns/rows and try again?
Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
Date format in Stream
Dave Pyett in Microsoft Stream Forum on
3 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies