![]() ![]() It chooses the sequencing of these numbers based on the day we want the week to begin from. The WEEKDAY function converts a date to a number between 1 and 7, one for each day of the week. If you’d rather use your own representation for the days of the week, you can use a formula based on both the WEEKDAY and CHOOSE functions.įirst, let us understand these two functions individually. ![]() Click OK to close the Format Cells dialog box.Īlso read: How to Convert Text to Date in Excel? Method 3: Converting Date to Day of Week in Excel using a Formula.You can type in “ ddd” if you want the short form or “ dddd” if you want the full form of the day. You can type in your format code in the Type field. This will display a number of formatting options on the right side, under Type.Under Category on the left side of the box, select the Custom option.This will open the Format Cells dialog box.Alternatively, you can select the dialog box launcher in the Number group under the Home tab. Right-click on your selection and select Format Cells from the popup menu that appears.Select all the cells containing the dates that you want to convert (A2:A8).You can use the Format Cells dialog box to convert your dates to days of the week as follows: As such you don’t need to have a separate column to type the formula. The Format Cells feature provides a great way to directly convert your dates to days of the week while replacing the existing dates. Also read: How to Convert Date to Serial Number in Excel? Method 2: Converting Date to Day of Week in Excel using the Format Cells Feature Note: Using this formula, your converted date is in text format, so you will see the results aligned to the left side of the cells. Here are some format codes along with the type of result you will get when applied to cell A2: Function The result you get in column B will differ according to the format code you used in step 2. We will first see how to convert the dates in column A to the format shown in column B in the image below: Let us see how we can apply the TEXT function to our sample dataset to convert all the dates to days of the week. if you apply =TEXT(A2, “dddd”), then it will return “Saturday”.if you apply =TEXT(A2, “ddd”) to the sample dataset, it will return “Sat”.if you apply =TEXT(A2, “dd”), then it will return “10”.if you apply =TEXT(A2, “d”) to the sample dataset, it will return “10”.dddd – full name of the day of the week (eg: Sunday, Monday).ddd – the day of the week in abbreviated form (eg: Sun, Mon).dd – two-digit representation of the day (eg: 03 or 30).d – one or two-digit representation of the day (eg: 3 or 30).You can use the following basic format codes to represent day values: Here are some basic building blocks for the format codes that you can use: Format Codes for Day of the Week or Month: Here, “ dddd” is the date_format code to display the day of the week corresponding to date in full words. The TEXT function applies the date_format_code that you specified on the provided date and returns a text string with that format.įor example, if you have the date “ ” in cell A2, then =TEXT(A2,”dddd”) will return “ Saturday”. date_format_code is the format code based on how you want the converted date to look.date is the date, date serial number, or reference to the cell that you want to convert.Here’s the syntax for the TEXT function: = TEXT (date, date_format_code) It takes a date serial number or date and lets you extract parts of the date to fit your required format. The TEXT function is a great function to convert dates to different text formats. Method 1: Converting Date to Day of Week in Excel using the TEXT Function Method 2: Using the Format Cells Feature. ![]()
0 Comments
Leave a Reply. |