Hi
If we presume the course is always a year (365 days) it would appear to be a
case of dividing this by the number of modules - according to your dates.
With the start date in A2 and the number of modules in B2, try this formula
in C2:
=A2+(365/B2)
This will give you the first date. In C3 down you can simply use
=C2+(365/$B$2)
and fill this down.
Format your cells as dates.

Hope this helps.
Andy.

"Dave_Lee" wrote in
message ...

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