•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to take daily/weekly rates from one table with varying time periods and calculate daily/weekly rates average across different time periods?
Hello,
I have a table such as below:
Date From: Date To: Weekly Rate:
01.01.24 23.02.24 £126
24.02.24 01.07.24 £158
02.07.24 08.03.25 £135
etc.
And I want to calculate averages on different timescales:
Date From: Date To: Weekly Rate:
01.01.24 30.06.24 Calculated Amount
01.07.24 31.12.24 Calculated Amount
01.01.25 30.06.25 £135
I also need to be able to show the last row has an average weekly rate of £135 even though over 3 months have yet to be reported.
Has anyone got any advice as to how I could achieve this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#real-time data collaboration
#real-time collaboration
#Excel alternatives
#financial modeling with spreadsheets
#daily rates
#weekly rates
#weekly rate
#average
#data table
#time periods
#calculations
#calculated amount
#varying time periods
#data analysis
#Date From
#Date To