Forum Discussion
Excel formula to get number of working days
here attached my workbook . i have data table and i have make a pivot table also for it.
there are machine names entry days and output. every day repeat all machine names but not work all machines. i need to get number of machines work on a day by day on new column in my pivot table
5 Replies
Please find the attached with the two Pivot Tables and see if any one of them is what you are trying to achieve.
thank you for the reply. this is not what i need. i need a pivot table just like your 1st pivot without extracting dates based on machine names. there should be only 6 rows for 6 days and only machine count work on this relevant date ( as a example except "0" output on output column.
Forget about the Pivot Table, just mock up the desired output manually based on the sample data in the file to show what exactly you are trying to achieve and upload the file again.
