Finding Maxium Date in Col E on sheet Dta

Results 1 to 5 of 5

Thread: Finding Maxium Date in Col E on sheet Dta

  1. #1
    Board Regular
    Join Date
    Jun 2006
    Posts
    4,811
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Finding Maxium Date in Col E on sheet Dta

     
    I have tried to use the following formula to find the maximum date in format mmm-yyyy that is in Col E on sheert 'Data"

    I use formatting in Col E as dd/mm/yyyy


    #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    CD
    1Jan-1900

    #DAE7F5 ;color: #161120">Summary



    #FFFFFF " >
    Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">
    CellFormula
    #DAE7F5 ;color: #161120">C1=TEXT(MAX(Data!E:E),"mmm-yyyy")





    #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    E
    231/10/2016
    331/10/2016
    430/11/2016
    530/11/2016
    631/12/2016
    731/12/2016
    831/01/2017
    931/01/2017

    #DAE7F5 ;color: #161120">Data





    It would be appreciated if someone could assist me

  2. #2
    Board Regular
    Join Date
    Oct 2015
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding Maxium Date in Col E on sheet Dta

    In excel, dates are stored as a number, so all you need to do to find the latest date is use =max(E2:E8) - replace the range E2:E8 as necessary.

  3. #3
    Board Regular
    Join Date
    Jun 2006
    Posts
    4,811
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding Maxium Date in Col E on sheet Dta

    I have tried that and it returns Jan-1900


    It should return Sept-2017

    #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    E
    2730/06/2017
    2830/06/2017
    2931/07/2017
    3031/07/2017
    3131/07/2017
    3231/08/2017
    3331/08/2017
    3431/08/2017
    3530/09/2017
    3630/09/2017
    3730/09/2017

    #DAE7F5 ;color: #161120">Data





    #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
    CD
    2Jan-1900

    #DAE7F5 ;color: #161120">Summary



    #FFFFFF " >
    Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">
    CellFormula
    #DAE7F5 ;color: #161120">C2=MAX(Data!E2:E5000)


  4. #4
    Board Regular
    Join Date
    Oct 2015
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding Maxium Date in Col E on sheet Dta

    If column E is formatted as text, then this solution will give the result you are getting. Try changing the format of the column.

  5. #5
    Board Regular
    Join Date
    Jun 2006
    Posts
    4,811
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding Maxium Date in Col E on sheet Dta

      
    Thanks for the advise

User Tag List

Tags for this Thread

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