Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Get Min & Max date from Pivot table field

    I have created a Pivot Table and one of the fields contains dates.

    How do I take the Min and Max date from the pivot table but I just want to show the Min and Max date on a different cell.

    So for example,

    CELL A:1 contains ="Date Period from " + Min(startdate) + " to " + Max(startdate)

    How do I get this working correctly?

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hello,

    Assuming StartDate is a named range, like this:

    ="Date Period from "&TEXT(MIN(StartDate),"dd mmm yy")&" to "&TEXT(MAX(StartDate), "dd mmm yy")



    In Excel formulas you can't use the + operator to concatenate strings.

  3. #3
    Join Date
    Oct 2007
    Posts
    127
    doesn't seem to work, i get the following error...

    #NAME?

  4. #4
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,
    In your example in post #1 you used "startdate". I assumed that this was a named range (I mentioned that in my post).
    If it isn't a named range, try using a range reference:

    ="Date Period from "&TEXT(MIN(C3:C10),"dd mmm yy")&" to "&TEXT(MAX(C3:C10), "dd mmm yy")

    Adjust C3:C10 as necessary.

    Hope that helps...

  5. #5
    Join Date
    Oct 2007
    Posts
    127
    thanks works perfectly

Posting Permissions

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