What does this function do?
Returns a number that indicates where the week falls numerically within a year.
Syntax:
WEEKNUM(serial_number,[return_type])
- Serial_number (required): A sequential number that represents the date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
- Return_type (optional): A number that determines the type of return value.
Return_type
|
Week Begins
|
1
|
Week begins on Sunday. Weekdays are numbered 1 through 7.
|
2
|
Week begins on Monday. Weekdays are numbered 1 through 7.
|
Examples:
=WEEKNUM("9/11/2014", 1) =46
=WEEKNUM("9/11/2014", 2) =45
=WEEKNUM("9/11/2014", 2) =45
If A1=9/11/2014
=WEEKDAY(A1, 1) = 46
No comments:
Post a Comment