UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Calculate Difference Between Dates In Pivot Table, Office 2013    
 
   
halefamily104
post Jul 3 2019, 10:27 AM
Post#1



Posts: 529
Joined: 7-November 10



Hello UA!


I am working on a pivot table and need some help. I have a "due date" and a "done date" and I want to show the number of days between the two dates. Is this possible? I have attached a snippit of how my pivot table is displayed. The cells highlighted in yellow are "due dates" and the ones in blue are "done dates". Any help will be appreciated!

Thanks again!
Attached File(s)
Attached File  Capture.JPG ( 11.89K )Number of downloads: 0
 
Go to the top of the page
 
Zaddicus
post Jul 8 2019, 08:25 AM
Post#2



Posts: 139
Joined: 3-April 19
From: Cardiff


Good Afternoon,

There are many ways to manipulate a pivot table so it is very possible to calculate the difference between 2 dates.

Here is a good site for learning some pivot filter basics

Half way down the page there is a section on "Difference From" that comes with a neat little youtube video, give it a go and hopefully you can get the pivot to do what you like.

I would offer to have a look but I despise pivot tables with every atom in my very body!

HTH

--------------------
~ Castiel


Skype: live:castielswift
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    29th January 2020 - 02:40 AM