Thank you Lars,This helped us figure out how to fix the formula!We went with this in the end, which works and is pretty much what you suggested.IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=1,{DE:oracleBriefingWeeksPrior}="REQUESTED BROADCAST DATE CANNOT BE A SATURDAY OR SUNDAY",IF(DAYOFWEEK({DE:o...