Thread: days of the week formulas
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_150_] Rick Rothstein \(MVP - VB\)[_150_] is offline
external usenet poster
  
Posts: 1
Default days of the week formulas
End of Period:

=A1+39-DAY(A1+32)-WEEKDAY(A1+32-DAY(A1+33))

I do not believe this formula works all the time. Unless I am wrong, it
fails for dates like 2/28/2008 through 3/1/2008, 3/29/2008 through 4/1/2008,
4/29/2008 through 5/1/2008, and so on.

Rick

Reply With QuoteReply With Quote