Payment terms function
 

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?

With the invoice date in A1 try:

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

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Tina" wrote in message
...
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?

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

"Tina" wrote in message
...
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?