+ Reply to Thread
Results 1 to 1 of 1

Formula to grab Dates from two Pivot Tables

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Question Formula to grab Dates from two Pivot Tables

    Hellooo! Brain Teaser here..

    Situation: I have a data set (Mock Data) with tasks and due dates. From this data set I have created TWO pivot tables. The two pivots measure different finish dates. From the pivots I have made a table to collect data as the pivot refreshes with columns based on the dates from the two pivots.

    Issue: I have written a formula that will update my row with the dates in order based on the two pivots. However, I have some issues that have occurred. Such as: when one pivot has a Date the other pivot does not. Right now, the formula checks if the two dates are the same, if they are it returns that date, if they are not it returns the lesser date. However, you can see in the excel file that this causes an issue when the greater date is left behind and never put in my row.

    Goal: I would like to manipulate (or completely change if there is a better way) my formula to account for this issue. The excel file is mock data that is a good representation of my issue. Two text boxes provide additional information.

    Thank you for any help and please let me know if I can provide additional information/clarification. Thanks!!!!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sorting dates- Pivot tables-
    By thursday140 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2016, 07:52 AM
  2. pivot tables with dates across columns
    By ammartino44 in forum Excel General
    Replies: 5
    Last Post: 04-14-2015, 06:24 PM
  3. [SOLVED] Macro that can grab dates within a parameterized list and insert rows with those dates
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2014, 09:14 AM
  4. Dates in pivot tables
    By amartino44 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2013, 01:00 PM
  5. Calculate orders past agreed dates in pivot table and averages in pivot tables
    By applesandpears in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-18-2012, 05:26 PM
  6. Pivot Tables and dates
    By JeffCPA in forum Excel General
    Replies: 3
    Last Post: 08-22-2010, 01:52 AM
  7. [SOLVED] Dates in Pivot Tables
    By Zani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2006, 10:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1