Here is my calculation:
=DateAdd("d",-1,DateAdd("d",56,DateAdd("d",-(IIf(Weekday([Cert_Date])=1,"0",Weekday([Cert_Date]-1))),[Cert_Date])))
I get "#Error" in the field when displayed. However, when I enter the [Cert_Date] for the calculation, it does calculate. So why is the error showing?
Thanks!