Microsoft ExcelWEEKDAY函数将返回1到7之间的整数,以表示Excel中给定日期的星期几。 WEEKDAY函数的语法 =WEEKDAY (serial_number, [return_type]) 语法参数 序列号–您将获得星期几的日期。 小技巧:serial_number具有以下几种输入方法: 1.您可以直接引用包含日期的单元格:=WEEKDAY(C1, 1). ...
WEEKDAYThe WEEKDAY function in Excel returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date.1. The WEEKDAY function below returns 2. 12/22/2025 falls on a Monday.2. You can also use the TEXT function to display the day of the week....
This article describes the formula syntax and usage of the WEEKDAY function in Microsoft Excel. Description Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. Syntax WEEKDAY(serial_number,[return_type...
This tutorial is talking about the formula syntax and usage of WEEKDAY function in Excel. Description of WEEKDAY function Syntax of WEEKDAY function Arguments of syntax Example of WEEKDAY functionDescription of WEEKDAY function The Microsoft Excel WEEKDAY function returns an integer number from 1 ...
WEEKDAY Formula in Excel The Formula for the WEEKDAY Function in Excel is as follows: Where serial_number: Serial number is the date value that you want to find out the weekday for or day of the week return_type: a return type is a number from 1 to 7 that identifies the week of ...
Excel WEEKDAY Function: Syntax & Arguments Syntax =WEEKDAY(serial_number, [return_type]) Return Values 0 to 7 (in numbers) Arguments ArgumentRequired/OptionalExplanation serial_number Required A number representing the day from which you want to find the day of the week return_type Optional ...
In this article, we’ll explain how to use theVBA Weekdayfunction in Excel. VBA Weekday Function (Quick View) Running this code will return7, because the date“1/1/2022”wasSaturday, and consideringSundayas the 1st day of the week, the number forSaturdayis7. ...
The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied to the function as an argument,
excel中weekday的用法 **Excel中WEEKDAY函数用法** **一、基本用法** In Excel, the WEEKDAY function is used to determine the day of the week for a given date. It returns a number that represents the day of the week, where 1 represents Sunday, 2 represents Monday, and so on up to 7 ...
The WEEKDAY function is available in all versions of Excel 365 through 2000. The syntax of the WEEKDAY function is as follows: WEEKDAY(serial_number, [return_type]) Where: Serial_number(required) - the date that you want to convert to the weekday number. It can be supplied as a seria...