Calulating a date

[f16bull]

Here is my question, If I have 12 cells relating to a date and want to be able input a date in any of those 12 cells I want 1 additonal cell to tell me a future date based on the date in any of the preceding 12 cells. The future date should be able to reflect 90, 180 or 360 days in the future, again based on the date input in either of the first 12 cells.

Ken

 

[acw]

Hi


Bit more detail. Are the positions in the 12 cells relevant?

How is the decision made whether to add 90, 180 or 360 days?

Tony

 

[f16bull]

The cells are relevent in that they assist in calculating a future date. For example. If i perform maintenance on a date in July I want it to forcast in 90, 180 or 360 days in the future for the next date that major maintenance would have to be performed

here is a brief example of what I have done so far

c9=c6(Now)+90 end result is the date in C6+90 days in the future for next Maint due

But ultimatly what I would like to work is that any cell in a particular row can have a date input into it and calculate it out instead of restricting it to one cell in the row as in the example.

Ken


Thanks for you assistance

 

[Yogi Anand]

Hi Ken:

How about ...

Book1
	C	D	E	F
5
6	11/24/2004
7
8
9	2/22/2005
10	5/23/2005
11	11/19/2005
12
Sheet1

formula in cell C9 is ... =$C$6+CHOOSE(ROWS($9:9),1,2,4)*90

this is then copied down.

 

[f16bull]

thanks, this might work for me. I might change it arounbd so that i can maniputlate a bit differently but should work. thanks




Ken

 

[Yogi Anand]

Hi Ken:

Good Job in making it work for you. Please post back if you need to discuss this further.

 

[f16bull]

Hello again,

here is a sample spreadsheet of what I would like to do for what ever reason I was unable to get the previous formulas that you provided to work.

Ken


DATES Next Due
Jan Feb Mar April




By entering a date in either of the above cells a date is given at the next due date of either 90, 180 or 360 from the date entered
[/url][/code]

 

[Yogi Anand]

Hi Ken:

Please post some sample Dates and your expected results ... and then let us take it from there.

 

[f16bull]

Well I thought I copied the spreadsheet and pasted it here but does not look as though it took. I will try to reattach it here so you can see my attempt


Ken

Thanks again for the assistance

 

[f16bull]

Ok one last question I seem to be having some problems with my date calculation still, although the informatin you forwarded was usefull I need to calculate the date differently.

Lets say for arguments sake I put a date in Row 5 cell A And want to project that date in Cell A 30 days out simple enought just tell Cell H for example to = Cell A + 30 days. Now to make it more complicated I want to input another date in Cell B Row 5 and again tell Cell H to equal that date + 30 days in the future again, so now I want cell H to recognize that date and forget the previous date input in Cell A and give me a new calculated date in cell H.

Thanks Again

Ken