1. column
  2. 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

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.