Jan 15 2022 08:58 AM
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.
Thanks
Jan 15 2022 09:02 AM
@siobhan1413 That should work as it always has. See picture, also 365.
Jan 15 2022 09:17 AM
@siobhan1413 Can you upload a screenshot with what you see?