If you’re working on scheduling or tracking data involving dates, you might want to include the day. Of course, that doesn’t sound particularly straightforward- at least not initially. Fortunately, it’s really quite simple.
Dates can be turned into days via the TEXT(cell, “dddd”) function. The TEXT(cell, “ddd”) function can be used to attain the shorthand of each day.
In this post we will be walking you through getting the day of week from a date in Excel. We hope you find this step-by-step guide useful.
Quick links:
- Getting the day of week from date in Excel via TEXT function
- Getting the day of week from date in Excel via CHOOSE function
- End note
Getting the day of week from date in Excel via TEXT function
Step 1 – Open your Excel sheet
- You’ll need to ensure you have a cell with a date, and an empty cell close to it. If you don’t have anything already, just copy the table shown in the image below.
Step 2 – Format the free cells with the TEXT function
- Using the TEXT(cell, “dddd”) function in the free cell, replace cell with a cell containing a date. When you stop editing the cell, its content will be presented as the date’s corresponding day.
- “dddd” returns full dates while “ddd” will return the shorthand
Step 3 – Check the function worked correctly
- If you do not say a date appear, check the cell is not too small — otherwise check you entered the function correctly.
Getting the day of week from date in Excel via CHOOSE function
Step 1 – Open your Excel sheet
- You’ll need to ensure you have a cell with a date, and an empty cell close to it. If you don’t have anything already, just copy the table shown in the image below.
Step 2 – Format the free cells with the TEXT function
- Using the function, CHOOSE(cell, “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, Saturday”) in an empty cell, replace cell with a cell containing a date.
- To achieve the same effect with the shorthand, you’ll need to replace the listed days with their shorthand equivalent. For instance: “Sun”, “Mon”, “Tue”, “Wed”, “Thu”, “Fri”, “Sat”.
Step 3 – Check the function worked correctly
- If you do not say a date appear, check the cell is not too small — otherwise check you entered the function correctly.
End note
Recap
A day of the week corresponding to a date can be attained via its date through the use of Excel’s built in TEXT function. The application is quite simple and only requires a cell containing a date, and an empty cell to contain the function (where the day will be displayed).
Farewell
As usual, this section is dedicated to thanking readers for their support. We’d be pleased to know you found this post useful and/or informative. If you have any more Office 365 related queries, please consult our related articles (listed below). However, if you have other queries, consider looking at the rest of the site. We’re frequently posting new stuff each week and may just have the guide or troubleshooting tips you need. Regardless, we wish you a good day/night. Farewell readers.
Our related articles:
- A complete guide to using OneDrive to transfer files to a new computer – OneDrive is a cloud storage platform offered as part of the Microsoft 365 suite. With it, your various folders and files may be stored online and downloaded for use from anywhere with an internet connection. As such, OneDrive is very useful if you’re looking to get files from one computer to another without wanting to mess around with storage devices.
- A complete guide to fixing OneDrive sync issues on Mac – OneDrive sometimes has issues, and many users have claimed that OneDrive isn’t synchronizing on their Mac OS devices, however, there are solutions available. In this blog, we will cover the most effective approaches to help users fix sync issues on their OneDrive devices. We will address some of the causes of why OneDrive won’t sync correctly and what users can do to help resolve these issues. Use the guide below to see how you can resolve OneDrive sync issues on Mac OS devices.
- Ways to delete a OneDrive shared library – OneDrive’s Shared libraries (or SharePoint sites) serve as large collections of various documents, media and content for your team/organization. In this post we’ll be giving you a short image guided walk through on deleting your OneDrive shared libraries. Additionally, to ease any potential confusion, we’ll also go over why you may still be seeing your shared library afterwards.
- Guide to deleting document libraries in SharePoint Online – SharePoint Online uses document libraries to store various files and folders created by you (the user). If a user for some reason decided they no longer required a document library, they could exercise the ability to delete it. Albeit, that requires actually knowing how to go about it. Fortunately for us, it’s quite straightforward. In this short post we’ll be guiding you through deleting document libraries with an image assisted walkthrough. We’ll additionally let you know why you may be unable to delete a certain library and under what circumstances your lost data can be restored.