Thread: Formula to display next Friday from B1 works except on the Friday itself.
View Single Post
  #2   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.
Hi,

Am Wed, 10 Aug 2011 05:40:38 -0700 (PDT) schrieb StargateFan:

=B1-WEEKDAY(B1-4,2)+8

If I input this week's Friday in B1 (August 12, 2011), the list starts
on August 19th in B2 when it should actually say August 12th. For all
other days of the week it seems to work fine.

try:
=B1+(MOD(B1-2,7)+15)*7+4-MOD(B1-2,7)


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