Average per month and average per day

[DGAL1]

I have sales for the entire year, and I want to calculate the count of transactions done on average per month and those done on average per day. Am using the column called ID to identify each transaction uniquely and a column for dat

[LRuCelver]

Avg([Transactions per day]) = [Total Transactions] / [Number of days]

Same is true for months and any other timeframe.