Diggyroo --

This works for me. If the date is in cell A1, then B1 might be:

=A1-WEEKDAY(A1)-1

That generated 3/7 through the end of the week, then 3/14.

HTH

"diggyroo" wrote:

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated