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