Manuals/calci/WEEKNUM

Revision as of 20:47, 24 October 2013 by MassBot1 (talk | contribs) (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=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.