Explanation
In this example, the goal is to get the day name (i.e.
Monday, Tuesday, Wednesday, etc.)
from a given date.
There are several ways to go about this in Excel, depending on your needs.
choose the date, and use theshortcut Control + 1 to open Format cells.
For example, in the worksheet shown, cell F5 contains the date January 1, 2000.
The date is lost in the conversion and only the text for the day name remains.
CHOOSE is a general-purpose function for returning a value based on a numeric index.
By default, WEEKDAY returns 1 for Sunday, 2 for Monday, 3 for Tuesday, etc.
For example, you’re able to use custom abbreviations or even abbreviations in a different language.
in a text string with the number format of your choice.
By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.
you’re able to use the WEEKDAY function inside other formulas to check the day of week.
The values provided to CHOOSE can include references.
