weekdayThe function is used to return the day of the week when the specified date is, and it is a commonly used date and time function in Excel. Here it is:weekdayBasic usage of functions:
weekday(serial_number, [return_type])
serial_number: Required, which indicates the day of the week on which you want to determine the date. It can be a cell reference that contains a date, or it can be a date value that is entered directly.
return_type: An optional parameter that indicates the type of day of the week to be returned. By default it is 1 (1 from Sunday, 2 on Monday, and so on), and you can also use other return types such as 0 (from Monday, 0 on Monday, 1 on Tuesday, and so on) or 2 (from Monday, 1 on Monday, 2 on Tuesday, and so on).
Here are some of the usesweekdayExample of a function:
1.If the date is a cell reference, e.g. a1 contains the date:
=weekday(a1)This will return the day of the week corresponding to the date in cell A1.
2.If you enter the date directly, for example"2023-12-01"：
=weekday("2023-12-01")
This will return the day of the week corresponding to the specified date.
3.Specify the return type:
=weekday("2023-12-01", 2)
This will return the day of the week from Monday, where Monday is 1, Tuesday is 2, and so on.
Please select an appropriate date or date cell according to the actual situation, and select the return type as you need.
Xi excel can help us process and analyze data better and improve work efficiency. It can be used to create charts, perform mathematical calculations, manage data, and more. In addition, as a widely used office software, mastering excel skills is very valuable in many professions, and I recommend a book to you.
Office software from the beginning to proficient in excel + word + ppt tutorial application ** book - essential cheats for the workplace!This book introduces the skills of office software in detail, so that you can quickly become an office master from scratch. Whether it's making a beautiful excel** or making a stunning PPT presentation, you can find the solution from this book. Buy now to boost your productivity and make your career easier!