In B4:
=IF(ROW()-3$E$2,"",$C$2+(ROW()-3)*INT(($D$2-$C$2)/$E$2))
then fill down to B11

HTH
--
AP

"Dave_Lee" a écrit
dans le message de news:
...

Hi this is the first time I've used this forum so I'm hoping someone can
help.

Here's the problem I'm working on a Spreadsheet that needs to generate
variable intervals in dates between 2 variable dates (confused, so am
I). The dates are the start and finish dates for college courses, so
theses change depending on the course. The variable intervals are the
finish dates for each module within the course so if a student has a
start date of 25/05/06 and a finish date of 25/05/07 and they have 5
modules to complete, the dates generated should be 06/08/06, 18/10/06,
30/12/06, 13/03/07 and 25/05/07. If the student has 4 module to
complete the dates generated should be 24/08/06, 23/11/06, 22/02/07 and
24/05/07 and so on. What if any formula can be used that will do
this?????

Any ideas greatly appreciated please see attached image.

Cheers


+-------------------------------------------------------------------+
|Filename: Spreadsheet.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4816 |
+-------------------------------------------------------------------+

--
Dave_Lee
------------------------------------------------------------------------
Dave_Lee's Profile:
http://www.excelforum.com/member.php...o&userid=34824
View this thread: http://www.excelforum.com/showthread...hreadid=545787