Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave_Lee
 
Posts: n/a
Default Dates and Intervals


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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Dates and Intervals

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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Dates and Intervals

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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Dates and Intervals

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" wrote in message
...
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





  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Dates and Intervals

You must click on the Open thread link

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









  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Dates and Intervals

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" wrote in message
...
You must click on the Open thread link

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









  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Dates and Intervals

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:
...
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" wrote in message
...
You must click on the Open thread link

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











  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave_Lee
 
Posts: n/a
Default Dates and Intervals


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



Cheers


--
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

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Dates and Intervals

Cheers Ardus! That'll do for me!

Andy.

"Ardus Petus" wrote in message
...
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:
...
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" wrote in message
...
You must click on the Open thread link

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













Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Displaying Dates and Intervals. Andy Charts and Charting in Excel 0 March 20th 06 11:01 AM
Chart Dates on X Axis Bill Martin Excel Discussion (Misc queries) 0 February 14th 06 05:01 PM
How do I combine a list of dates & a value into 1 week intervals Nathan Woodson Excel Discussion (Misc queries) 0 January 20th 06 02:39 AM
Variable dates on X axis evenly spaced (should not be) Leo Bueno Charts and Charting in Excel 1 July 24th 05 04:16 PM
Charting data against dates where dates are not at fixed intervals PK Charts and Charting in Excel 4 June 16th 05 05:08 AM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"