Hi guys, I'm just trying to get my head around pivot tables in excel and I've come to a problem.
I'm aiming to calculate the number of holidays someone has booked in a certain month between to dates.
In my spreadsheet I have 3 columns
Name
Start Date
Finish Date
Days: using the function NETWORKDAYS to calculate working days less public holidays.
Now in my Pivot Table I have "Name" in the rows and "Sum of Days" in the Data area.
This is fine for seeing the total number of working days someone has booked a holiday but is there a way of making the pivot table only display the days booked off in a certain month?
e.g. Bob has booked a holiday from the 22/01/08 to 06/02/08 which is 12 working days but I'd like the pivot table to show me how many of these days are in February for payroll.
I'm thinking of making a Pivot table for each month on seperate sheets and a grand total for the year. If you can think of an easier way of doing it in excel let me know. I already have a SQL database to do a similar thing but i wanted to try something in excel similar just as an exercise in stretching my skills
I'm aiming to calculate the number of holidays someone has booked in a certain month between to dates.
In my spreadsheet I have 3 columns
Name
Start Date
Finish Date
Days: using the function NETWORKDAYS to calculate working days less public holidays.
Now in my Pivot Table I have "Name" in the rows and "Sum of Days" in the Data area.
This is fine for seeing the total number of working days someone has booked a holiday but is there a way of making the pivot table only display the days booked off in a certain month?
e.g. Bob has booked a holiday from the 22/01/08 to 06/02/08 which is 12 working days but I'd like the pivot table to show me how many of these days are in February for payroll.
I'm thinking of making a Pivot table for each month on seperate sheets and a grand total for the year. If you can think of an easier way of doing it in excel let me know. I already have a SQL database to do a similar thing but i wanted to try something in excel similar just as an exercise in stretching my skills