I have a delivery schedule in an Excel file, and on a regular basis I have to determine the day of the week of a future date. Does Excel have a way to speed the operation?
I asked a colleague, and he surprised me with a simple solution.
Highlight the target cells, click on Format, Cells and the Number tab. Then click on Custom. In the box in the Type column, type dddd f or the full name of the week and ddd for abbreviated names…
…and it does the job automatically.