I need to return the week ending date (Friday) for any given date entered in the first column (A). My billing cycle week ends on a Friday, and the new billing week technically starts the next day (Saturday).
I have used the following formula, but it calculates the end of the week as Saturday. So, when I enter a Saturday (the start of a new billing cycle), it returns the date from the preceding Friday (the day before). All other days of the week return the proper Friday date (Sun -- Friday) How can I modify this formula so that Saturday is the start of the week and Friday is the end of the week?

A1+6-WEEKDAY(A1,1))