Just another guess.. With C4 housing the start date, if E2 is supposed to
house the date of 1st payment, F2 the date of 2nd payment, and so on, then
we could put in E2: =$C4+28*COLUMN(A1)
and copy E2 across
This will return all the successive payment due dates
(every 28 days) in E2, F2, G2, etc
Eg: if the date in C4 is: 01-Feb-06, then E2: G2 will return:
01-Mar-06, 29-Mar-06, 26-Apr-06
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Winston" wrote in
message ...
Hi
What I am trying to do is forcast forward in calender a payment every 4
weeks, this 4 weeks calculation starts from a start date which is
variable, the $C4=the start date and $D4=the cell where payment amount
is returned from.
Wob
--
Winston
------------------------------------------------------------------------
Winston's Profile:
http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=507433