On Wed, 12 Mar 2008 14:41:04 -0700, 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


=A1-WEEKDAY(A1-6)
--ron