You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

Learn to create a zero-click Excel workflow with automation tools like Office Scripts and Power Automate. Save time and ...

Converting other returns to annual You can convert from weekly or monthly returns to annual returns in a similar way. Simply replace the 365 with the appropriate number of return periods in a year.