Calculating a Date for the Future

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Niki6 - 19 Sep 2005 21:57 GMT

I am trying to find a formula to calculate a date in the future. Let me
explain what I mean.... I work for a radio station and I have to form a
prize database. Listeners are only aloud to win once every ninety days.
I have 10 columns that have unfilled dates since a date will only be
entered into that column once the listener has won. Now, I have an 11th
column that I would like to automatically calculate a 90 day period when
the listener will be able to win again. Here is where my problem is, I
want that 11th column to update once I enter a second, third, fourth,
etc date for that specific listener and it always to calculate a 90 day
period from the second, third, fourth, etc date without having to put a
new formula in every time this happens. Can this be done?

Signature

Niki6

Reply to this Message

BorisS - 19 Sep 2005 22:13 GMT

Pretty sure that if the 11th cell of any row reads "max(range of previous 10
cells)+90", you should be good. It'll take the highest date out of the cells
in the range (which, of course, copy individually to each row and so only
refer to the immediate left 10 cells) and just add 90 days to it.

Signature

Boris

> I am trying to find a formula to calculate a date in the future. Let me
> explain what I mean.... I work for a radio station and I have to form a
[quoted text clipped - 7 lines]
> period from the second, third, fourth, etc date without having to put a
> new formula in every time this happens. Can this be done?

Reply to this Message

bill k - 19 Sep 2005 22:28 GMT

=MAX(A1:J1)+90
should do the trick

extend down the column as far as you need to
using the right hand borrom corner of cell K

--
bill

Reply to this Message

Niki6 - 19 Sep 2005 23:49 GMT

Thanks!! This did the trick, your awesome!!

bill k Wrote:

> =MAX(A1:J1)+90
> should do the trick
>
> extend down the column as far as you need to
> using the right hand borrom corner of cell K

Reply to this Message

Cutter - 19 Sep 2005 22:28 GMT

Assuming your first date column is A and your first row containing
date is 2:

In K2 type:

=IF(A2>0,MAX(A2:J2)+90,"")

Copy this formula down as far as is necessary

Reply to this Message