set payment date 28 days after following friday

[rhydim]

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

[Bob Phillips]

=(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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =(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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>

[Bob Phillips]

Sandy,

I read that as if today is a saturday or sunday, start on the next monday,
then goto Friday, then add 28. I think though that by reading it in that
convoluted manner, I concocted a convoluted formula. Your method of getting
the lat Friday and adding 35 seems much more direct.

--
HTH

Bob Phillips

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

"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> [email protected]
> [email protected] with @tiscali.co.uk
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >
=(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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >
> >
>
>