- column
- TECHNOLOGY Q&A
Excel Translates a Date Into a Day
BY STANLEY ZAROWIN
Please note: This item is from our archives and was published in 2007. It is provided for historical reference. The content may be out of date and links may no longer function.
Related
November 10, 2026
What Binance’s $6.3B crypto hack means for CPAs
November 1, 2026
Why AI needs to show its work
November 1, 2026
How firms make AI adoption work for them
TOPICS
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.
