View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andrewc
 
Posts: n/a
Default A weekly equivalent of EOMONTH


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