Microsoft ExcelWEEKDAY函数将返回1到7之间的整数,以表示Excel中给定日期的星期几。 WEEKDAY函数的语法 =WEEKDAY (serial_number, [return_type]) 语法参数 序列号–您将获得星期几的日期。 Tips:serial_number具有以下几种输入方法: 1.您可以直接引用包含日期的单元格:=WEEKDAY(C1, 1). ...
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 Function in Excel The weekday function is an inbuilt function in excel for getting the Weekday sequence as per the selected Return Type in the syntax. As we know that a week has 7 days starting from Sunday to Saturday, considering Sunday a Week Off. Here, we just have to select...
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....
WEEKDAY Function in Excel The WEEKDAY function takes the date value ( as number ) in the argument and return number corresponding to the weekday. Syntax: =WEEKDAY( date_value, [Return Ttype]) date_value : date value as number or using cell reference ...
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 ...
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...
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,
WEEKDAY Function in Excel and Google Sheets to get the day of the week (1-7).Calculate Day of Week from a DateThe WEEKDAY Function Returns the day of the week as a number (1-7) of a date.By adding the CHOOSE Function you can return the name of the day of the week:...