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

 

[Yogi Anand]

Hi Ken:

I suggest you post your data using HTMLmaker (Colo's Cool utility) along with your expected result, so we can see what you are working with -- and then let us take it from there!

 

[f16bull]

Ok, Can you explain to me how to do thism I dowloaded the code make but am not exacly sure how to get my worksheet to post here

Ken

 

[KleptoOne]

is the second or third date that you enter always going to be greater than the previous dates entered?

 

[f16bull]

yes it will be I use it for forcasting what work will be done in the future
based on the last date input

 

[KleptoOne]

Then in cell H5, use this formula:

=INDEX(A5:G5,MATCH(MAX(A5:G5),A5:G5,0))+30

It will find the newest date entered in A-G and add 30 to that.
Let me know if this works for you.

 

[f16bull]

I will try it thanks,

Any Idea on how to post the actuall worksheet here I downloaded the HTML make but still unsure of how to get it to post the worksheet


Ken

 

[2rrs]

I will try it thanks,

Any Idea on how to post the actuall worksheet here I downloaded the HTML make but still unsure of how to get it to post the worksheet


Ken

Have a look here:
http://www.mrexcel.com/board2/viewtopic.php?t=92622

 

[KleptoOne]

I swear, I overcomplicate things way too much. The formula I used was a dumb way of getting this:

=MAX(A5:G5)+30

As for colo, I've personally never used it, sorry.

 

[f16bull]

Book2
	A	B	C	D	E	F	G	H
1
2
3		Jan	Feb	Mar	April	May	June	NextDue
4	Customer1	01/01/02
5	Customer2	12/27/04
6
7	Wouldliketoinputadateintoeitheroftheabovecells,
8	whereifIputadateinMonthJanitgivesme
9	acalculateddaterangeof+90daysinthenextduecellect,ect
10	butIalsowanttobeabletoinputanewdatein
11	eitherofthefollowingmonthsanditcalculatinganew"NextDue"date
12	therebycancellingouttheprevious"NextDue"date
13
14
15
16
Sheet1

 

[KleptoOne]

input MAX(B4:G4)+90 in cell H4 and copy down.