Forum Discussion
QuickBaseCoachD
10 years agoQrew Captain
Not tested but try this
IF(LastDayOfPeriod([Week Ending], Weeks(2), Date(2016,2,27)) = LastDayofWeek([Week Ending]),2,1)
The magic is in this formula function here
https://www.quickbase.com/db/6ewwzuuj?a=dr&rid=42&rl=j9
IF(LastDayOfPeriod([Week Ending], Weeks(2), Date(2016,2,27)) = LastDayofWeek([Week Ending]),2,1)
The magic is in this formula function here
https://www.quickbase.com/db/6ewwzuuj?a=dr&rid=42&rl=j9