I have random dates on column A and would like to get the weekending Friday date on the next column. Is there a formula for that? Your assistance will be greatly appreciated.

Thanks!