[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
- Change type using cell format
- use function
Change type using cell format
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.
=CHOOSE(WEEKDAY(D4),"日","一","二","三","四","五","六")
The above is the application of [Excel] day of the week, I hope it can help you
References
Like my work? Don't forget to support and clap, let me know that you are with me on the road of creation. Keep this enthusiasm together!