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