Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Displaying Dates and Intervals. | Charts and Charting in Excel | |||
Chart Dates on X Axis | Excel Discussion (Misc queries) | |||
How do I combine a list of dates & a value into 1 week intervals | Excel Discussion (Misc queries) | |||
Variable dates on X axis evenly spaced (should not be) | Charts and Charting in Excel | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |