[=+D19+GETPIVOTDATA("Apr-17",$A$3)]
I am trying to find an easier way to copy this formula by pulling down to the next cell; however I am wanting the date to change to the next date. Is this possible?
[=+D19+GETPIVOTDATA("Apr-17",$A$3)]
I am trying to find an easier way to copy this formula by pulling down to the next cell; however I am wanting the date to change to the next date. Is this possible?
Make the APR-17 a cell reference in its own column then make the formula reference THAT cell instead.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
What is the Next Date ?
Is the 17 representing the 17th day of April, or the Year 2017 ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks