| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Earlest Date Based On A Date Using Min Formula
I'm triyng to get the earlest date under DATE1 (coloumn A) based on a date
under DATE 2 (coloumn B) by using the MIN formula. DATE 1 DATE 2 4/30/2008 4/30/2008 4/30/2008 4/30/2008 4/29/2008 4/30/2008 4/28/2008 4/29/2008 4/27/2008 4/29/2008 =MIN(IF(B2:B6="4/30/2008",A2:A6)) 4/27/2008 is the answer I get. But it should be 4/29/2008. Can someone show the correct formula for this? -- Cue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| input a date or update it based on date in another cell | New Users to Excel | |||
| earlest date not complete | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
