If you mean that given a date, you want to calculate the date of the ending Friday in a Sat...Fri week, try =
Datefield - DayOfWeek ( Datefield +1 ) + 7
You da man!!! Thanks so much...calculation worked perfectly! I will pay this forward (as they say).