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?


--
Niki6
------------------------------------------------------------------------
Niki6's Profile: http://www.excelforum.com/member.php...o&userid=27377
View this thread: http://www.excelforum.com/showthread...hreadid=468972

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.
--
Boris


"Niki6" wrote:


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?


--
Niki6
------------------------------------------------------------------------
Niki6's Profile: http://www.excelforum.com/member.php...o&userid=27377
View this thread: http://www.excelforum.com/showthread...hreadid=468972

=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 K1


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=468972

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

In K2 type:

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

Copy this formula down as far as is necessary.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=468972

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 K1


--
Niki6
------------------------------------------------------------------------
Niki6's Profile: http://www.excelforum.com/member.php...o&userid=27377
View this thread: http://www.excelforum.com/showthread...hreadid=468972