Find Daily Employee Spend Amounts

The goal here is to summarize the average monthly amount each employee spent on reimbursement. Each person does not spend money on the same amount of days, so I am trying to calculate two things: 1.) the count of unique days per month per employee and 2.) the average amount spent per month per employee based on that count of days.

What I have done already: I have created a pivot table with

Rows:
Employee
Months(Transaction Date)
Transaction Date

Value:
Sum of Approved Amount

and I used the formula =SUM(IF(COUNTIF(range, range)=1,1,0)) to find unique amounts of days in a column to the right of the pivot table. So then I copy the entire three columns, paste on another sheet, and filter by color so that only the data I need is there.

You can easily find a per-day amount based on this. In this method, you still have to have a middle step and specify the ranges, but I am stumped on how to make the range-finding process easier or if I am approaching this in a hard way overall. There are 250+ employees, so it is a lot to go through to add a range for each month for each employee.

Any ideas for improvement would be awesome!