The WEEKNUM Function[1]is an ExcelDATE and TIME Function. It is often overlooked but can quite useful when utilized properly. Basically, the WEEKNUM function will return the week number of a specific date as per the calendar year. The function will return an integer that represents a week nu...
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 ...
Use the WEEKDAY function in Excel to determine the day of the week for a given date, enabling easy date-related analysis.
Excel WEEKDAY function returns the day of the week as the number. It can be very helpful if you are managing a small event calendar in Excel.The Excel WEEKDAY Function returns the day of the week as the number WEEKDAY Function: A Brief The Excel WEEKDAY Function is used to return a ...
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....
The Excel WEEKDAY function returns the day number of the week from a date serial number. The default ranges from 1 for Sunday, through to 7 for Saturday.
If the serial_number argument is empty, the WEEKDAY function still returns '7.' If the value supplied in the serial_number argument is non-numeric, the function returns a #VALUE error. If the serial_number argument falls outside of Excel's database or the return_type argument is unrecogni...
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...
Method 4 – Combining CHOOSE and WEEKDAY Functions in Excel to Convert a Date to the Day of Week The CHOOSE function returns a value from given list values based on the index number. Steps: Enter cell C5. Copy and paste the following formula. =CHOOSE(WEEKDAY(B5),"Sunday","Monday","Tu...
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...