Forum Discussion
MichelleChapman
7 years agoQrew Assistant Captain
That's what it looks like based on the other formula that doesn't have the right start date...not the new ones you are trying to help me understand...
QuickBaseCoachD
7 years agoQrew Captain
Here is a simplified version using your process date
Create a formula date field called
Ending Saturday of First Week of Year
LastDayOfWeek(FirstDayOfYear(Today()))
Create a field for Week number
var text
var number WeeksSinceFirstWeek =
(ToDays(LastDayOfWeek([Process date])-[Ending Saturday of First Week of Year]))/7;
$WeeksSinceFirstWeek+1
Create a formula date field called
Ending Saturday of First Week of Year
LastDayOfWeek(FirstDayOfYear(Today()))
Create a field for Week number
var text
var number WeeksSinceFirstWeek =
(ToDays(LastDayOfWeek([Process date])-[Ending Saturday of First Week of Year]))/7;
$WeeksSinceFirstWeek+1