Forum Discussion
Excel formula to get number of working days
thank you!
i like a pivot table like table 3 on the attachment without extracting data and except "0" on output
While inserting the Pivot Table, on Create Pivot Table dialog box, check the option at the bottom which says "Add this data to the Data Model.
Once the Pivot Table is inserted at the desired destination, right click on Range in the Pivot Table Fields List and choose Add Measure and in the next Measure window, type a Name for the Measure and paste the formula given below in the Formula box and click ok to finish.
Then drag the Dates in the Rows area and New Measure you created in the Values Area.
Formula for Measure:
=CALCULATE(COUNTROWS(Range),Range[Output MC]>0)
Please refer to the attached for more details where I create a Measure called "Number of Machines".