Thread: 4weeks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Winston
 
Posts: n/a
Default 4weeks


Hi all

I need to calc the following left to right from start date per day

If day = last day amount stated in cell = 4 weeks then amount is
shown?

The formula I tried does not work =IF(($C4+28)=(E2),$D4,"") it just
does the first 28 days and does not do the next 6 months

Can anyone help?

Wob


--
Winston
------------------------------------------------------------------------
Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=507433