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.

Solving the Weekly to Monthly Data Conversion Challenge in DHIS2. In my work with health information systems, particularly DHIS2, I've encountered a common challenge: converting weekly data to monthly ...