Dates and Intervals

**Dave_Lee** · 05-26-2006, 05:41 AM

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

05-26-2006, 06:10 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Ardus Petus · 05-26-2006, 06:15 AM

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" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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
>

05-26-2006, 06:30 AM

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> a écrit
> dans le message de news:
> [email protected]...
>>
>> 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
>>
>
>

Ardus Petus · 05-26-2006, 06:35 AM

You must click on the Open thread link

<Andy> a écrit dans le message de news:
[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> a
>> écrit dans le message de news:
>> [email protected]...
>>>
>>> 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
>>>
>>
>>
>
>

05-26-2006, 06:50 AM

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" <[email protected]> wrote in message
news:[email protected]...
> You must click on the Open thread link
>
> <Andy> a écrit dans le message de news:
> [email protected]...
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>>> 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" <[email protected]> a
>>> écrit dans le message de news:
>>> [email protected]...
>>>>
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>

**Dave_Lee** · 05-26-2006, 08:12 AM

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

Cheers

Ardus Petus · 05-26-2006, 08:15 AM

I'm using OE too.

I meant: click on the last thread of the OP, the one that says
:
>>>>> View this thread:
>>>>> http://www.excelforum.com/showthread...hreadid=545787

HTH
--
AP

<Andy> a écrit dans le message de news:
%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> You must click on the Open thread link
>>
>> <Andy> a écrit dans le message de news:
>> [email protected]...
>>> 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" <[email protected]> wrote in message
>>> news:[email protected]...
>>>> 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" <[email protected]> a
>>>> écrit dans le message de news:
>>>> [email protected]...
>>>>>
>>>>> 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

05-26-2006, 08:35 AM

Cheers Ardus! That'll do for me!

Andy.

"Ardus Petus" <[email protected]> wrote in message
news:[email protected]...
> I'm using OE too.
>
> I meant: click on the last thread of the OP, the one that says
> :
>>>>>> View this thread:
>>>>>> http://www.excelforum.com/showthread...hreadid=545787
>
> HTH
> --
> AP
>
> <Andy> a écrit dans le message de news:
> %[email protected]...
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>>> You must click on the Open thread link
>>>
>>> <Andy> a écrit dans le message de news:
>>> [email protected]...
>>>> 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" <[email protected]> wrote in message
>>>> news:[email protected]...
>>>>> 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" <[email protected]> a
>>>>> écrit dans le message de news:
>>>>> [email protected]...
>>>>>>
>>>>>> 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
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>