Thread: Formula to display next Friday from B1 works except on the Friday itself.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Formula to display next Friday from B1 works except on the Friday itself.
Am Wed, 10 Aug 2011 06:36:10 -0700 (PDT) schrieb Don Guillett:

=B1-WEEKDAY(B1,3)+IF(WEEKDAY(B1,3)4,11,4)

or
=B1+(WEEKDAY(B1,2)5)*7+(5-WEEKDAY(B1,2))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote