Date display as day formula stopped working

New Contributor

Hi there


Previously I could formulate a cell to show me which weekday a certain date was - =TEXT(A1,"DDDD"). However, since November when my 365 renewed and everything updated, this has stopped working.


Is there a workaround/updated formula that I am missing? It gets a bit tedious checking which weekday this is and dropping the weekday isn't an option for the needs of this file.



3 Replies

@siobhan1413 That should work as it always has. See picture, also 365.

Screenshot 2022-01-15 at 18.00.49.png

Thanks. I'll keep trying.

@siobhan1413 Can you upload a screenshot with what you see?