Forum Discussion
MatthewMatthew1
10 years agoQrew Trainee
Fixed. The reference date should be the starting date of the period, which would be the 28th, not the 27th.
If(LastDayOfPeriod([Week Ending], Weeks(2), Date(2016,2,28)) = LastDayOfWeek([Week Ending]),2,1)
Thank you!
If(LastDayOfPeriod([Week Ending], Weeks(2), Date(2016,2,28)) = LastDayOfWeek([Week Ending]),2,1)
Thank you!