Forum Discussion
MichelleChapman
7 years agoQrew Assistant Captain
So do you have a field for week that has this formula that tends to pull Week 53-
var number WeeksSinceFirstWeek =
(ToDays(LastDayOfWeek([date])-[Ending Saturday of First Week of Year]))/7;
$WeeksSinceFirstWeek+1)
Then a [Week number] field with this formula to move week 53 to Week 1?
If([Week number]>52,1,[Week number]
Then just hide the Week field and display Week Number instead?
var number WeeksSinceFirstWeek =
(ToDays(LastDayOfWeek([date])-[Ending Saturday of First Week of Year]))/7;
$WeeksSinceFirstWeek+1)
Then a [Week number] field with this formula to move week 53 to Week 1?
If([Week number]>52,1,[Week number]
Then just hide the Week field and display Week Number instead?