I can't reproduce what you're trying to do.
But anyway, when copying to the right it is unlikely that the $-signs are
correct. Try the formula without them.
Or specify in a bit more detail what you're trying to do.

--
Kind regards,

Niek Otten

"Winston" wrote in
message ...

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