Thread: Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date.
View Single Post
  #6   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default
On Thu, 29 Sep 2005 13:40:02 -0400, Ron Rosenfeld
wrote:

=F3-DAY(F3)+8-WEEKDAY(F3-DAY(F3)+6).

That should read:

=P1-DAY(P1)+8-WEEKDAY(P1-DAY(P1)+7)
--ron
Reply With QuoteReply With Quote