I have this following formula, can some one please help me modify this.
This formula looks in column AC and adds 10 working days in that date, but if in column C value = "Assy", then it does not count.
But is it possible when I have "Assy" in column C, then i want to see "N/A" in the cell, other wise add 10 working days to that date.
=IF(ISERROR(AC6/AC6)=TRUE,"",IF(C6="Assy",AC6,WORKDAY(AC6,(10))))
Thanks in advance
This formula looks in column AC and adds 10 working days in that date, but if in column C value = "Assy", then it does not count.
But is it possible when I have "Assy" in column C, then i want to see "N/A" in the cell, other wise add 10 working days to that date.
=IF(ISERROR(AC6/AC6)=TRUE,"",IF(C6="Assy",AC6,WORKDAY(AC6,(10))))
Thanks in advance