Manuals/calci/WEEKNUM

Revision as of 17:05, 11 July 2018 by Devika (talk | contribs)
WEEKNUM (Value,Type)


where,

  • represents a date for which week number has to be displayed,
  • represents the type of return value.

WEEKNUM() converts a serial number to a number representing where the week falls numerically with a year.


Description

WEEKNUM(Value, Type)

  •   and   are required arguments.
  •   is a date value to be entered either in 'date format' or 'dates returned using formulas'.
  • If   values are invalid, Calci displays #N/A error message.
  •   is the type of return value. It can be from the following -
Type Description
1 Number from 1(Sunday) to 7(Saturday)
2 Number from 1(Monday) to 7(Sunday)
  • If   values are invalid, Calci displays #N/A error message.
  • We can use Range values also. For Example: WEEKNUM(#10/28/2013-12/28/2013,1)
  • #date notation needs mm/dd/yy format .

Examples

Consider the following example that shows the use of WEEKNUM function:

10/8/2014
2/10/2013
=WEEKNUM(A1,1): Calculates the number of the week in the year for date mentioned in A1 and return type '1'. 
Displays 41 as a result. =WEEKNUM(B1,2): Calculates the number of the week in the year for date mentioned in A1 and return type '2'.
Displays 6 as a result. =WEEKNUM(DATE(2013,10,28),1) : Calculates the number of the week in the year for date mentioned and
return type '1'. Displays 44 as a result.

Related Videos

WEEKNUM

See Also

References