Formula within Pivot Table Calculated Field - Days in time period

S

Sathyendra Nandula

- Created a Pivot in Excel 2010 using data in Data sheet
- Data contains Date, time, directional market, # of departures
- I want to be able to compute round trip departures that is (#departures/days in calender month)

- I am able to compute Number of calender days by clicking AVERAGE on the Date field and get 30 or 31 days.

- How can i type a formula within the Calculated Field (where u make customized formulas) to compute =average(date) ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
SUM & OFFSET & PIVOT TABLE?? 0
Copy Pivot calculated field to another pivot 0
Formula to display Count of Days in given month, using list of Startand End Dates 2
Sub Totals as a calculated field in a pivot table 2
Pivot Table Calculated Field 0
Delete Pivot Table Calculated Field 2
Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB 4

Top