+ Reply to Thread
Results 1 to 4 of 4

Automatic update of date criteria in excel formula pulled from a Pivot table

  1. #1
    Registered User
    Join Date
    08-24-2017
    Location
    Tennessee, USA
    MS-Off Ver
    Office 2013
    Posts
    11

    Automatic update of date criteria in excel formula pulled from a Pivot table

    =GETPIVOTDATA("Count of Case #",'export data'!$AB$38,"FH Name","City-State","Month-Year",DATE(2019,5,1))

    Is there a way to have the formula recognize the date field in the Pivot table (2019,5,1); without having to update it each month. For this formula, I updated the 4 (april) to a 5 for May. I would like to automate this monthly task if possible on several spreadsheets

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    2,806

    Re: Automatic update of date criteria in excel formula pulled from a Pivot table

    You could simply enter the date in a cell and refer to that from the GETPIVOTDATA formula(s).
    Rory
    There's a row going on down near Slough

  3. #3
    Registered User
    Join Date
    08-24-2017
    Location
    Tennessee, USA
    MS-Off Ver
    Office 2013
    Posts
    11

    Re: Automatic update of date criteria in excel formula pulled from a Pivot table

    Tried that but it didnt seem to work; maybe i am typing the formula incorrectly...

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    2,806

    Re: Automatic update of date criteria in excel formula pulled from a Pivot table

    What exactly did you try, what happened, and what was in the cell you used as a reference?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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