On Aug 10, 8:00*am, Claus Busch wrote:
Hi,

Am Wed, 10 Aug 2011 05:40:38 -0700 (PDT) schrieb StargateFan:

=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.

try:
=B1+(MOD(B1-2,7)+15)*7+4-MOD(B1-2,7)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Or
=B1-WEEKDAY(B1,3)+IF(WEEKDAY(B1,3)4,11,4)