If "payment due date" fall on friday till monday, "payment date"=next tuesday.
Otherwise payment date=next friday.
I have written this formula with 8 "if statement", but pls help me to simplify the formula since i would like to add more complicated formula to the same line
=if(k4="blm submit","blm submit",if(weekday(k4)=1,k4+2,if(weekday(k4)=2,k4+1,if(weekday(k4)=3,k4+3,if(weekday(k4)=4,k4+2,if(weekday(k4)=5,k4+1,if(weekday(k4)=6,k4+4,if(weekday(k4)=7,k4+3))))))))
see attachment for details. Also see sheet#2="payment day table"
Bookmarks