Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |