Excel FunctionsExcel WEEKNUM Function


Used to return the serial number of a week within a year (1-52) for the given date. The WEEK function can be useful in various nested functions and can provide input for functions while excel modeling.

Remember not to confuse WEEKNUM function with WEEKDAY function in which number a day within the week is returned by Excel


The WEEKNUM function syntax has the following argument:

  • Serial_Number Required.

A date within the week.

  • Return_type Optional.

A number that determines on which day the week begins. The default is 1 (Monday)

Note: Avoid directly punching dates into Excel function, instead of either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel will read the date as ZERO.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.