Followinf Friday of a certain day

[Alfredo_CPA]

I have in cell "A5" one day of the month
I need a formula in "A6" that gives me the following
friday of that specific day based on the input on "A5"

Any ideas??
Thanks

 

[Bob Phillips]

=A1+6-WEEKDAY(A1)

 

[Peo Sjoblom]

=A5+8-WEEKDAY(A5+2)

--


Regards,


Peo Sjoblom

 

[John C]

Doesn't quite work, if A5 is a Saturday.

=A5+7-(WEEKDAY(A5+1))

 

[Alfredo_CPA]

Thanks John
It works perfect
P.S. for other members: the formula gives you the following Friday of that
day (including the day itself ). If you don;t want to include the day itself
then, please use
Peo posting

 

[Alfredo_CPA]

Thanks Peo
It works perfect
P.S. for other members: the formula gives you the following Friday of that
day (without including the day itself ). If you want to include the day
itself then, please use John posting

 

[John C]

Thanks for the feedback
--
John C

Thanks John
It works perfect
P.S. for other members: the formula gives you the following Friday of that
day (including the day itself ). If you don;t want to include the day itself
then, please use
Peo posting