rucifa
rucifa

[Excel] Application of the day of the week

In fact, today's date is the day of the week in Excel, which is quite common; it's just that I sometimes use this function, but sometimes I forget how to use it, so another purpose of typing this article is to record that I will use it. some features of

  1. Change type using cell format
  2. use function

Change type using cell format

Enter two dates based on content

Right-click the content you want to convert to the day of the week and select "Cell Format"

In the "Value" tab → Category (C) select "Date" → Type (T) select "Wednesday"

The original content of the Gregorian calendar has become the day of the week

use function

Since I want to simply express it as "day one, two, three, four, five, six", I use a function here to achieve what I want.

Enter the function in the memory cell of F4
 =CHOOSE(WEEKDAY(D4),"日","一","二","三","四","五","六")
The following cell is made in the same way (directly pull the cell after the input function and go down to the lower right)

The above is the application of [Excel] day of the week, I hope it can help you

References

Excel Small Classroom - Two ways to display the date of the week (non-function, function two)
CC BY-NC-ND 2.0

Like my work?
Don't forget to support or like, so I know you are with me..

Recommendations

Comment…