I found a formula for displaying the next Friday from the user input
date in B1. It works great except if the input date is a Friday. I
need a spreadsheet that shows invoicing dates, which occur every
Friday. But if the start date happens to be a Friday, need to have
the list include that Friday.

=B1-WEEKDAY(B1-4,2)+8

If I input this week's Friday in B1 (August 12, 2011), the list starts
on August 19th in B2 when it should actually say August 12th. For all
other days of the week it seems to work fine.

Thanks in advance for any help.

Cheers! :oD