Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display latest arrival date
In Cell U5 enter =max(P5:T5)
"Annabelle" wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display latest arrival date
Excellent! Thank you for your help.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display latest arrival date
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull latest date data - ignore the rest | Excel Worksheet Functions | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Latest date from multiple list | Excel Worksheet Functions | |||
Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions | |||
avanced filtering for latest date | Excel Discussion (Misc queries) |