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
Get Clients Ready for Tax SeasonThis comprehensive report looks at the changes to the child tax credit, earned income tax credit, and child and dependent care credit caused by the expiration of provisions in the American Rescue Plan Act; the ability e-file more returns in the Form 1040 series; automobile mileage deductions; the alternative minimum tax; gift tax exemptions; strategies for accelerating or postponing income and deductions; and retirement and estate planning.
