In Excel I want to add 8 days to dates in a column unless the start date is a Saturday, in which case I want to add 9 days.
If A1 has 01-01-2014
then in B1 I want 09-01-2014
.
If A2 has 04-01-2014
(a Saturday) then in B2 I want 13-01-2014
.
Please try =IF(MOD(A1,7)=0,A1+9,A1+8)
.