I have the following if function (IF([Audit Start Date]3, ([Audit End Date]3 + 7), "Audit to be Scheduled") and I get Invalid data type.
the formula works when there is no date in column. However, formula does not work when there is a date in column.
I dont know what else to try. This formula works in excel...