Dates and Intervals

[Dave_Lee]

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

Here's the problem I'm working on a Spreadsheet that needs to generat
variable intervals in dates between 2 variable dates (confused, so a
I). The dates are the start and finish dates for college courses, s
theses change depending on the course. The variable intervals are th
finish dates for each module within the course so if a student has
start date of 25/05/06 and a finish date of 25/05/07 and they have
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 t
complete the dates generated should be 24/08/06, 23/11/06, 22/02/07 an
24/05/07 and so on. What if any formula can be used that will d
this?????

Any ideas greatly appreciated please see attached image.

Cheer

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

 

[Guest]

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.

 

[Ardus Petus]

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

HTH

 

[Guest]

Hi Ardus.
You have obviously been able to see the spreadsheet - but I cant. Do I need
to be a member of ExcelForum?

Thanks.
Andy.

 

[Ardus Petus]

You must click on the Open thread link

Hi Ardus.
You have obviously been able to see the spreadsheet - but I cant. Do I
need to be a member of ExcelForum?

Thanks.
Andy.

 

[Guest]

I'm using OE and there isn't an Open Thread option to click on! If I click
on the link, it opens the site but says it is an invalid attachment - and to
contact the site administrator.
I get the same response when I try to view any attachments on that
particular site that are posted here.
Andy.

 

[Ardus Petus]

I'm using OE too.

I meant: click on the last thread of the OP, the one that says
:
HTH

 

[Dave_Lee]

Ardus that works perfectly, thanks very much exactly what I needed.



Cheers

 

[Guest]

Cheers Ardus! That'll do for me!

Andy.

I'm using OE too.

I meant: click on the last thread of the OP, the one that says
:

HTH