Thread
:
Dates and Intervals
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Posts: n/a
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
Reply With Quote