Difference between revisions of "Manuals/calci/WEEKNUM"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
(No difference)
|
Revision as of 21:47, 24 October 2013
Syntax
Examples
''''''' ''''
Description
This function gives a number that indicates where the week falls numerically within a year.
WEEKNUM
Let's see an example in Column1Row1
[javascript:ToggleDiv('divExpCollAsst_4') C1R1 = February 14,2007]
[javascript:ToggleDiv('divExpCollAsst_4') I.e.=WEEKNUM(C1R1,1) is 7]
Column1 | Column2 | Column3 | Column4 | |
Row1 | February 14,2007 | 7 | ||
Row2 | ||||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |
WEEKNUM(d,n)
where d is a date within the week and n is a number that determines on which day the week begins.