Alphacsulb
Active Member
- Joined
- Mar 20, 2008
- Messages
- 414
=IF(A4<>"",IF(WEEKDAY(A4+10,2)=6,A4+12),IF(WEEKDAY(A4+10,2)=7,A4+11),IF(WEEKDAY(A4+10,2)>6,A4+10),"")
I'm getting "You've entered too many arguments for this function."
I'm trying to get this formula to say:
IF A4 is not blank then:
Check to see if A4+10 days is a Saturday, if it is then add 2 days,
If A4+10 is a Sunday then add 1 day,
If A+10 is a weekday then A4+10 days,
Otherwise leave it blank.
I'm sure its simple but cant figure out what is wrong.
I'm getting "You've entered too many arguments for this function."
I'm trying to get this formula to say:
IF A4 is not blank then:
Check to see if A4+10 days is a Saturday, if it is then add 2 days,
If A4+10 is a Sunday then add 1 day,
If A+10 is a weekday then A4+10 days,
Otherwise leave it blank.
I'm sure its simple but cant figure out what is wrong.