=(A1+(WEEKDAY(A1,2)5)+(WEEKDAY(A1,2)6))+6-WEEKDAY(A1+(WEEKDAY(A1,2)5)+(WE
EKDAY(A1,2)6))+28

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rhydim" wrote in message
...
sale on a monday aug 2 need to calulate 28 days after following friday for
payment date. if this falls on sat or sun needs to move to monday