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.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

SPONSORED REPORT

Getting leases in line

ASC Topic 842 is a relatively simple standard that can mean profound changes for organizations with leases. This report examines what makes this standard challenging and describes new ways for CPAs to add value.