Payment terms function

[Tina]

I have customers that have their own payment terms, for example they will pay
on the following monday after 33 days of the invoice date. I have figured
out how to determine the date they will be due after 33 days, but can I get
it to give me the date of the Monday after the 33 days?

 

[Sandy Mann]

With the invoice date in A1 try:

=A1+33-WEEKDAY(A1+33,3)

HTH

Sandy

 

[N Harkawat]

=CHOOSE(WEEKDAY(A1+33,1),1,0,6,5,4,3,2)+A1+33