Bob,

Perhaps it is my reading of the question but surely 28 days after the
following Friday can never be a Saturday or Sunday.

=A1-WEEKDAY(A1-6,1)+35

Seems to return the same date as your formula.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Bob Phillips" wrote in message
...
=(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