Excel Translates a Date Into a Day

BY STANLEY ZAROWIN


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.

SPONSORED REPORT

Implementing a global statutory reporting maturity model

Assess your organization's capabilities and progress toward an ideal state of global statutory reporting. Sponsored by Workiva.

100th ANNIVERSARY

Black CPA Centennial, 1921–2021

With 2021 marking the 100th anniversary of the first Black licensed CPA in the United States, a yearlong campaign kicked off to recognize the nation’s Black CPAs and encourage greater progress in diversity, inclusion, and equity in the CPA profession.