Week Over Week Calculator

How to use this week-over-week calculator

What this calculator does

This calculator measures the percentage change between one week and the immediately following week. It is useful for short-cycle monitoring of revenue, orders, sessions, leads, support tickets, production units, or another nonnegative metric measured consistently in both periods. The result is an exact percentage-change identity for the two values entered; it does not prove why performance changed, remove seasonality, or determine whether a one-week movement is statistically significant. The standard percentage-change method is also described in the U.S. Census Bureau guidance on percentage change.

When to use it

Use it to check whether a campaign lifted weekly conversions, compare weekly sales after a price change, monitor near-term traffic or customer-service volume, or prepare a concise operating dashboard. For highly seasonal metrics, compare the result with several prior weeks or a year-over-year benchmark before drawing conclusions.

How to calculate

1. The calculator opens with a demonstration: an initial value of 10,000 and a following value of 12,500. The result and a validated Excel workbook are immediately available.
2. Replace Value in initial week with the baseline. Enter a plain nonnegative decimal using a period as the decimal separator; commas, currency symbols, percent signs, and scientific notation are rejected.
3. Replace Value in following week with the next week's value. Results update as you type.
4. Read Week-over-week % change, then use Absolute change, Following ÷ initial, and Direction to understand the same movement in complementary ways.
5. Select Download Excel to export the current typed inputs, outputs, formula steps, and comparison table. Select Reset to clear the demonstration and calculated state; export stays disabled until a complete valid pair is entered again.

Input guide

Value in initial week is required and must be greater than zero because it is the denominator in the percentage-change formula. A realistic entry is 10,000. A larger baseline reduces the percentage impact of the same absolute movement. Entering zero is a common mistake: percentage change from a zero baseline is undefined, so the calculator rejects it rather than displaying infinity. Value in following week is also required and may be zero or any finite nonnegative number. A realistic entry is 12,500. Raising it increases both the absolute and percentage change; lowering it can produce a decline as low as – 100% when the following value is zero.

Output guide

Week-over-week % change is the primary result. Positive values indicate growth, zero means no change, and negative values indicate decline. Absolute change is the following value minus the initial value in the original units. Following ÷ initial is a unitless multiple: 1.00× means equal, 1.25× means 25% higher, and 0.80× means 20% lower. Direction labels the result Growth, No change, or Decline. The summary pills repeat direction, signed absolute change, and the multiple. The Weekly comparison table lists each period's value, change from initial, and an index where the initial week equals 100. These are exact transformations of the entered values, not forecasts or recommendations.

Worked example

With 10,000 in the initial week and 12,500 in the following week, the difference is 2,500. Divide 2,500 by 10,000 to get 0.25, then multiply by 100. The displayed week-over-week change is therefore 25.00%. The ratio is 1.2500×, the following-week index is 125.00, and the direction is Growth. The startup workbook uses these same values and results.