Have questions or feedback about Office VBA or this documentation? The VBA Weekday Function returns an integer (from 1 to 7), representing the day of the week for a supplied date.An optional FirstDayOfWeek enumeration value, specifying the weekday that should be used as the first day of the week.The following examples use the VBA Weekday function to return the day of week for the date 12/31/2015 (a Thursday).Note that, in the above call to the Weekday function, the Note that, in the above call to the VBA Weekday function, the ' Return the weekday for the date 12/31/2015 (first day of week is Sunday)' Return the weekday for the date 12/31/2015 (first day of week is Thursday) The syntax of the function is: Weekday( Date , [FirstDayOfWeek] ) Next, we use the Weekday function (build in function) to check whether dateToCheck is a weekday or not. Description. The Microsoft Excel WEEKDAY function returns a number representing the day of the week, given a date value. Please re-enable javascript in your browser settings. Jour de la semaine (Date, [ premierjoursem ])Weekday(date, [ firstdayofweek]) La syntaxe de la fonction Weekday est composée des arguments nommés suivants :The Weekday function syntax has these named arguments:
Example: for i = 3, Excel VBA checks date1 + 3 days. The Microsoft Excel WEEKDAY function returns a number representing the day of the week, given a date value.The WEEKDAY function is a built-in function in Excel that is categorized as a The syntax for the WEEKDAY function in Microsoft Excel is:Optional. Functions (Visual Basic for Applications) Support and feedback. 5. It determines the day to use as the first day of the week in the calculations.Let's look at some Excel WEEKDAY function examples and explore how to use the WEEKDAY function as a worksheet function in Microsoft Excel:Based on the Excel spreadsheet above, the following WEEKDAY examples would return:The WEEKDAY function can also be used in VBA code in Microsoft Excel.Let's look at some Excel WEEKDAY function examples and explore how to use the WEEKDAY function in Excel VBA code:In this example, the variable called LWeekday would now contain the value of 2.While using this site, you agree to have read and accepted our We use advertisements to support this website and fund the development of new content.TechOnTheNet.com requires javascript to work properly.
The WEEKDAY function is a built-in function in Excel that is categorized as a Date/Time Function.It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. See also. The WEEKDAYNAME function is a built-in function in Excel that is categorized as a Date/Time Function.It can be used as a VBA function (VBA) in Excel. Format: WeekDay … WeekDay() Description: The WeekDay function takes Date as a parameter and returns a number between 1 and 7, that is the week day of the date provided. Description. June 19, 2014. The Microsoft Excel WEEKDAYNAME function returns a string representing the day of the week given a number from 1 to 7. The Weekday function returns 1 for a Sunday and 7 for a Saturday. Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

The above VBA code combines the WeekdayName function with the Weekday function, to return the weekday name for the date 12/31/2015. The VBA Weekday Function returns an integer (from 1 to 7), representing the day of the week for a supplied date. MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 4 because ' MyDate represents a Wednesday. Therefore, after running the above VBA code, the variable wkday is equal to the String "Thursday".