It is possible to make use of Excel’s functions within a pivot. Generally speaking though you would need to use the Calculated Field options (you can find out more about Calculated Fields in our eBook).
In this case it would be as simple as pointing to the fields with the start and end dates. Because you can’t use the function wizard within the calculated field dialogue box, you will need to remember the syntax of any function you want to use.
MS Excel in 2 minutes per week
Like what you’ve learnt above? Get a free 2 minute(or less) video clip once a week via our social media sites.
Easy to subscribe and unsubscribe, this is a good way to see what we can offer.
Learn more on the ‘Excel in 2 minutes’ page or click on the relevant icon to go to your preferred social media platform. The order of video clips release differs for each platform so subscribe to more if you want to learn quicker.