If you have a date in cell C4 and you want a date that is 28 days later in
cell D4 then in D4 put =C4+28, and if you want 28 days after that in E4 just
drag the D4 formula over to E4 or Copy and pste it from D4 to E4 and on and
on for as far as you need.

Vaya con Dios,
Chuck, CABGx3


"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