monthly data from daily

I have a weird question: I have a budget spreadsheet that has three columns one Payee, another the day of the month paid, and then the amount. This is fine for services paid monthly, but may I also include annual and semi-annual services? For example, I have a phone plan that is paid $480/year...

I would like to automatically calculate the revenue for each month based on the collection date. For example $13.16 per day from Jan 5th to Jan 31st calculated when I enter data for amount collected in February. Then Feb to to use $13.16 per day from the 1st to the 12th and $19.05 from the 13th...

Hi, I have a 684x684 data set for daily retention metrics thats that I want to consolidate into Monthly. <tbody> 1/1/15 1/2/15 1/3/15 1/4/15 ... ... 10/27/16 10/28/16 10/29/16 1/1/15 10 9 8 7 6 6 3 2 2 1/2/15 - 12 10 8 7 7 4 3 2 1/3/15 - - 14 13 12 11 5 4 3 1/4/15 - - - 16 15 10 6 5...

Hey guys, I would like to find the monthly median price of daily transactions. For an average I can use a pivot table, but it does not have the median function build in. I have calculated the daily median value using an array formula...