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?
|