Formula to pull Min & Max Date

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Formula to pull Min & Max Date

  1. #1
    New Member
    Join Date
    Jun 2003
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula to pull Min & Max Date

     
    I am looking for a formula that will look at the value in the WeekA column and bring back the min SD and the max FD. The Min Start column is the value I should get for all cells in WeekA with 17.

    SD FD WeekA Min Start Max Finished
    03/31/03 04/22/03 17 3/31/2003 4/23/2003
    04/02/02 04/23/03 17 3/31/2003 4/23/2003
    10/15/02 11/15/02 46
    10/16/02 11/14/02 46

    Any help would be greatly appreciated. Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to pull Min & Max Date

    If I understand your requirements your posted results are incorrect (2002<2003)...

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl2002 XP : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    1
    SDFDWeekAMin StartMax Finished
    2
    3/31/20034/22/2003174/2/20024/23/2003
    3
    4/2/20024/23/2003174/2/20024/23/2003
    4
    10/15/200211/15/20024610/15/200211/15/2002
    5
    10/16/200211/14/20024610/15/200211/15/2002
    6
    7
    8
    9
    Sheet1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  3. #3
    New Member
    Join Date
    Jun 2003
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I apologize, it was a typo. My problem has been solved, thank you very much.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com