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({DEracleRequestedBroadcastDate})=1,{DEracleBriefingWeeksPrior}="REQUESTED BROADCAST DATE CANNOT BE A SATURDAY OR SUNDAY",IF(DAYOFWEEK({DEracleR...