May 31 2021 05:00 PM
May 31 2021 10:35 PM
I'm not sure how to get what you want from a PivotTable.
However, Excel has made several improvements over the past few years so you can do the needful on your own (assuming you have the appropriate version of Excel).
* your data are in a table as Excel understands it (Insert | Table) and
* that the job of interest is in H2.
Then the 1st formula will give you a list of unique dates for the job and the 2nd formula will give you a count of the unique dates.
May 31 2021 10:55 PM
Thank you for your suggestions.
I have managed to get the information by including a formula into the data spreadsheet which counted only when the date changed, then refreshed the pivot table so that it showed the actual number of days worked.