WeekOfYear
Returns the number of weeks after January 1 of the year of a date.
Format
WeekOfYear ( date )
Parameters
date - any calendar date
Data type returned
number
Originated in version
6.0 or earlier
Description
Fractions of weeks occurring at the beginning or end of the year count as full weeks, so the WeekOfYear function returns values 1 to 54.
Example 1
WeekOfYear ( "1/1/2019" ) returns 1.
WeekOfYear ( ProjectDue ) returns 6, when ProjectDue is 2/2/2019.
WeekOfYear ( "1/1/2019" ) - WeekOfYear ( "2/2/2019" ) returns -5.