Thread: a formula that returns the previous fridays date
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default a formula that returns the previous fridays date
On Wed, 12 Mar 2008 15:41:01 -0700, pdberger
wrote:

=A1-WEEKDAY(A1)-1

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

But he wanted 3/7 until 3/14
--ron
Reply With QuoteReply With Quote