Date Formulas in CRW 7.0

[Shepard123456]

Given a known date, I would like to create a formula that returns the <b>week number</b> of the year in which it belongs.&nbsp;&nbsp;For instance, January 4 falls in the 2nd week of the year 2000.&nbsp;&nbsp;Any known formulas to compute this??

 

[gol4]

go to <A HREF="

http://www.seagatesoftware.com\downloads"

TARGET="_new">

http://www.seagatesoftware.com\downloads</A><br>search

for file called <br><br>UFLDATE.EXE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>Compatible with versions: 4.5 and higher<br><br>Adds two functions to the &quot;Additional Functions&quot; portion of the Formula Editor.&nbsp;&nbsp;DayOfYear returns a numeric value of <br>this will add a User function library which will give these functions<br><br>the day of the year that a Date field represents.&nbsp;&nbsp;WeekOfYear returns a numeric value of the number of the week that a Date field falls in for the given year. <br><br>&nbsp;U2LDATE.DLL<br><br>&nbsp;UFLDATE.DLL<br><br>DayOfYear Returns a number representing the day of the year (1-366)<br>WeekOfYear Returns a number representing the week number (1-53) based on Sunday being the first day of a week.<br><br>