=A1+6-WEEKDAY(A1)

--
__________________________________
HTH

Bob

"Alfredo_CPA" .(donotspam) wrote in message
...
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