WEEKNUM Function
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to 52 representing the corresponding week …
return_type
WEEKDAY Function
The WEEKDAY Function in Excel returns an integer that represents a day of the week.