Hello,
I have a label in a gallery with the following calculation:
Text(DateAdd(ThisItem.EV_Date, -1))
Is there a way this formula can be amended to state that if EV_Date lands on a Monday, then the date is to show Fridays date, but any other day it is to show the day before date?
thanks