• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Shop
  • Show Search
Hide Search
Home » How To » How to Get the Name of a Day from a Date in Excel

How to Get the Name of a Day from a Date in Excel

October 10, 2016

Got a series of dates in Excel and want to know how to get the name of a days they fall on? Here’s a quick Excel guide to help you with that using a simple formula with some variations. Here’s how to get the name of a day from a date.

How to Get the Name of a Day from a Date in Excel

Full Form

There are a few different ways in which you can get this information. Let’s say you only want the full name returned, such as Tuesday, you need to make use of the formula : =TEXT(A1,”dddd”)

So if we wanted to know when 10-8-16 fell on, we enter the formula in another cell to get the result as Wednesday.

how-to-get-the-name-of-a-day-from-a-date-in-excel-full-name

Abbreviated Form

If on the other hand, if you want a day showing up only in the abbreviated format, you use the formula, =TEXT(A1,”ddd”). This will return the result, Wed.

how to get the name of a day from a date in excel abbreviated name

Custom Format

If on the other hand, you want to spice up your day names with something more snazzy, you can create a custom name list and get Excel to display that name instead of the standard names. The function is:

=CHOOSE(WEEKDAY(A1),”XXX Sunday “, “XXX Monday”, “XXX Tuesday”, “XXX Wednesday”, “XXX Thursday “, “XXX Friday”, “XXX Saturday”)

where XXX is the custom name you give to the day.

For example, your formula can read like this:

=CHOOSE(WEEKDAY(A1),”Happy Sunday “, “Moody Monday”, “Dowdy Tuesday”, “Mayhem Wednesday”, “Thirsty Thursday”, “Freaky Friday”, “Sleepy Saturday “)

where XXX is the custom name you give to the day.

In this function, we use the WEEKDAY function, which returns a number from 1 to 7. 1 is indicative of Sunday and 7 of Saturday. If you want to change which day of the week starts with 1 you’ll need to append a number to the weekday function.

ALSO READ:  How to Write Complex Excel Formulas

When you enter the function =WEEKDAY(A1), it will return the result of 1, which is a Sunday. If cell A1 has the date we used in our example, 10-8-16, it will return a result 4.

If you want Monday to be the starting day of the week, you use this function:

=WEEKDAY(A1, 2) and if you want Tuesday to be the starting day of the week, you use the function=WEEKDAY(A1, 3). In our example, if we used =WEEKDAY(A1, 2) on the date 10-8-16, it will return a result 3.

weekday-function

So back to our custom dates. Let’s use the function, =CHOOSE(WEEKDAY(A1),”Happy Sunday “, “Moody Monday”, “Dowdy Tuesday”, “Mayhem Wednesday”, “Thirsty Thursday”, “Freaky Friday”, “Sleepy Saturday “) on our date. Here’s what we get in return:

custom-day-names

So that’s it folks! Getting the name of a day from a date is easy if you remember these simple functions and rules.

If you found this tutorial helpful, be sure to check out more good stuff in our Learn Excel series. If you want to learn Excel from scratch, consider taking up our Udemy course, Excel 2016 for Beginners. It is available at a nominal price of just $10.

Tweet5
Share1
WhatsApp
Pin1
Buffer
7 Shares

Filed Under: How To Tagged With: excel how to, learn excel

You May Also Like

How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel
How to Combine Text with a Date or Time in Excel
How to Combine Text with a Date or Time in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Fast External SSD Gadgets for your Mac - TATFI

4 Fast External SSD Gadgets for your Mac (2021)

Anker Powerhouse 100 - TATFI

Charge Your iPhone, Galaxy, iPad, or MacBook with the Portable Power Bank Anker Powerhouse 100

Logitech Circle View - TATFI

Logitech Circle View – A Great Wired Outdoor Camera for HomeKit Users

Spigen Galaxy S21 Cases - TATFI

Spigen Galaxy S21 Cases is Perfect for New Samsung Smartphone

Samsung Galaxy SmartTag Bluetooth Tracker - TATFI

Find Lost Items with the Samsung Galaxy SmartTag Bluetooth Tracker

Popular Tags

android android apps android games android how to apple chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.

TheAppTimes © 2021 // Runs on StudioPress