Display latest arrival date

CELLS
P5 is the original date and Q5 through T5 are cells for up to four
possible move dates (schedule changes). U5 is the target arrival date.

QUESTION
In U5, I want to show the most current target arrival date. If there
are no schedule changes, this would be P5, but if there is a schedule
slip, I want the most current date to appear. If the schedule slipped
once, this would be Q5; if the schedule has slipped three times, this
would be S5.

Is there a formula that could accomplish this task?

EXAMPLE1
P5 - 02/01/06
Q5 -
R5 -
S5 -
T5 -
U5 - 02/01/06

EXAMPLE2
P5 - 02/01/06
Q5 - 02/05/06
R5 - 02/10/06
S5 -
T5 -
U5 - 02/10/06

EXAMPLE3
P5 - 02/01/06
Q5 - 02/05/06
R5 - 02/10/06
S5 - 02/11/06
T5 - 02/15/06
U5 - 02/15/06

In Cell U5 enter =max(P5:T5)

"Annabelle" <[email protected]> wrote in message
news:[email protected]...
> CELLS
> P5 is the original date and Q5 through T5 are cells for up to four
> possible move dates (schedule changes). U5 is the target arrival date.
>
> QUESTION
> In U5, I want to show the most current target arrival date. If there
> are no schedule changes, this would be P5, but if there is a schedule
> slip, I want the most current date to appear. If the schedule slipped
> once, this would be Q5; if the schedule has slipped three times, this
> would be S5.
>
> Is there a formula that could accomplish this task?
>
> EXAMPLE1
> P5 - 02/01/06
> Q5 -
> R5 -
> S5 -
> T5 -
> U5 - 02/01/06
>
> EXAMPLE2
> P5 - 02/01/06
> Q5 - 02/05/06
> R5 - 02/10/06
> S5 -
> T5 -
> U5 - 02/10/06
>
> EXAMPLE3
> P5 - 02/01/06
> Q5 - 02/05/06
> R5 - 02/10/06
> S5 - 02/11/06
> T5 - 02/15/06
> U5 - 02/15/06
>

Excellent! Thank you for your help.

In U5 put this formula:
=IF(T5="",IF(S5="",IF(R5="",IF(Q5="",P5,Q5),R5),S5),T5)
(Don't forget to format P5 - U5 as "Date")

This is assuming you don't need to go any further as there is a limit
of 7 nested IFs in Excel.

This is al sp assuming that the contents of P5 thru T5 have either a
date or are empty. If they have a "0" in them then change the "" to
0.

HTH

-Minitman

On 21 Feb 2006 05:12:40 -0800, "Annabelle" <[email protected]>
wrote:

>CELLS
>P5 is the original date and Q5 through T5 are cells for up to four
>possible move dates (schedule changes). U5 is the target arrival date.
>
>QUESTION
>In U5, I want to show the most current target arrival date. If there
>are no schedule changes, this would be P5, but if there is a schedule
>slip, I want the most current date to appear. If the schedule slipped
>once, this would be Q5; if the schedule has slipped three times, this
>would be S5.
>
>Is there a formula that could accomplish this task?
>
>EXAMPLE1
>P5 - 02/01/06
>Q5 -
>R5 -
>S5 -
>T5 -
>U5 - 02/01/06
>
>EXAMPLE2
>P5 - 02/01/06
>Q5 - 02/05/06
>R5 - 02/10/06
>S5 -
>T5 -
>U5 - 02/10/06
>
>EXAMPLE3
>P5 - 02/01/06
>Q5 - 02/05/06
>R5 - 02/10/06
>S5 - 02/11/06
>T5 - 02/15/06
>U5 - 02/15/06