=A1-CHOOSE(WEEKDAY(A1),1,2,3,4,5,0,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"andrewc" wrote in
message ...

Hi,

I use the EOMONTH function to return the dates 1 month, 3 months etc
back from a base date. Can someone please tell me how to do the same
using a specified number of weeks rather than months.

For example, if the base date is 23/02/06, what is the date at the end
of the previous week if one defines the end of a week as a Friday?

Any help would be much appreciated.

Regards,
Andrew


--
andrewc
------------------------------------------------------------------------
andrewc's Profile:
http://www.excelforum.com/member.php...o&userid=19613
View this thread: http://www.excelforum.com/showthread...hreadid=515738