Edit week length
I have a field that calculates Week Of based on the date that someone enters for each record. I have set Sunday to be the displayed date for the Week Of field using the formula: PrevDayofWeek([Date...
Forum Discussion
Try this for the WeekOf formula
If(DayOfWeek([Date])=0, [Date], PrevDayOfWeek([Date], 0))
If(DayOfWeek([Date])=0, [Date], PrevDayOfWeek([Date], 0))
Worked like a charm, thank you!