Month over Month Percent Change Calculator

This calculator works out the month-over-month percentage change between two values, such as revenue, website traffic, or inventory. You enter the previous month’s value and the current month’s value, and you get the percent increase or decrease, along with the absolute difference. The result tells you the rate of change from one month to the next, which is a common way to track short-term trends.

Formula

The month-over-month percent change is calculated with this formula:

Percent change = ((Current month value − Previous month value) / Previous month value) × 100

Where:

• Previous month value – the amount from the earlier month (e.g., January).
• Current month value – the amount from the later month (e.g., February).
• Percent change – the relative increase or decrease, expressed as a percentage. A positive number means growth; a negative number means a decline.

The absolute difference (Current − Previous) is also shown, but it is not a percentage—it is the raw change in the same units as your inputs.

Worked Example

Using the default values: previous month = 1,000, current month = 1,150.

1. Subtract the previous value from the current value: 1,150 − 1,000 = 150.
2. Divide that difference by the previous value: 150 ÷ 1,000 = 0.15.
3. Multiply by 100 to get a percentage: 0.15 × 100 = 15%.

So the month-over-month change is 15%, and the absolute difference is 150 units. This matches the calculator’s output.

When to Use Month-over-Month Change

Month-over-month (MoM) change is useful for spotting short-term trends in metrics that you track regularly. Common applications include:

• Sales revenue or units sold
• Website visits, unique visitors, or conversion rates
• Inventory levels or production output
• Customer support tickets or complaints
• Social media followers or engagement

Because it compares only two consecutive months, MoM change is sensitive to seasonal effects. For example, retail sales often jump in December and fall in January; a January MoM figure will show a large negative change even if the business is healthy. For that reason, many analysts also look at year-over-year (YoY) change, which compares the same month in two different years, to remove seasonality.

How to Read the Result

A positive percent change means the current month’s value is higher than the previous month’s. A negative percent change means it is lower. A result of 0% means no change.

The size of the percentage depends on the magnitude of the previous value. A change from 10 to 11 is a 10% increase, while a change from 100 to 101 is only a 1% increase, even though the absolute difference is the same (1 unit). This is why percentages are useful for comparing relative growth across different scales.

When the previous month’s value is zero or negative, the formula breaks down. Division by zero is undefined, and a negative denominator produces a percentage that is hard to interpret. In those cases, report the absolute difference instead, or use a different metric.

Common Mistakes and Pitfalls

• Reversing the order: Always subtract the previous value from the current value. If you reverse them, the sign flips and you get the wrong direction.
• Using the wrong base: The denominator is always the previous month’s value, not the current one. Some people mistakenly divide by the current value, which gives a different number.
• Mixing units: Ensure both values are in the same units (e.g., both in dollars, both in kilograms). If one is in thousands and the other is in millions, convert first.
• Rounding too early: Round only at the final step. If you round intermediate numbers, you can introduce noticeable errors, especially with small percentages.
• Ignoring context: A 50% increase from 2 to 3 is not the same as a 50% increase from 200 to 300. Always consider the absolute change alongside the percentage.

Limitations of the Formula

The month-over-month formula assumes that the previous month’s value is a meaningful baseline. It does not account for:

• Seasonality: Comparing December to January will often show a drop that is not a real decline in business health.
• Irregular months: February has fewer days than March, so a daily metric like sales per day will naturally differ. Use daily averages if the number of days varies.
• Zero or negative baselines: If the previous value is zero, the formula is undefined. If it is negative, the percentage becomes counterintuitive (e.g., a change from −10 to −5 gives +50%, which may misleadingly look like growth).
• Compounding effects: MoM changes are not additive over time. A 10% increase followed by a 10% decrease does not bring you back to the original value—it leaves you 1% lower.

For long-term analysis, consider using a rolling average or year-over-year comparison to smooth out noise.

Month-over-Month vs. Year-over-Year

Month-over-month compares consecutive months (e.g., February vs. January). Year-over-year (YoY) compares the same month in two consecutive years (e.g., February 2025 vs. February 2024). YoY is less affected by seasonality and is often preferred for annual trends. MoM is more responsive and can catch sudden shifts, but it is noisier. Many dashboards show both: MoM for short-term momentum and YoY for the underlying trend.

Frequently Asked Questions

How do I calculate month-over-month percent change in Excel?

If your previous month is in cell A1 and the current month is in cell B1, use the formula =(B1-A1)/A1*100. Format the cell as a percentage or keep the multiplication by 100. Make sure A1 is not zero, or you will get a division error.

What does a negative month-over-month change mean?

A negative result means the current month’s value is lower than the previous month’s. For example, if revenue fell from $10,000 to $9,000, the MoM change is −10%. This indicates a decline, but the reason could be seasonal, operational, or random.

Can I use this calculator for any two time periods, not just months?

Yes, the same formula works for any two periods—weeks, quarters, years—as long as you label them correctly. The math is identical; only the interpretation changes. For example, week-over-week change uses the same formula with weekly data.

Why do I get a different answer if I calculate percentage change from the current value?

Because the denominator is different. Month-over-month change always uses the previous month as the base. If you divide by the current month instead, you get the percentage change relative to the new value, which is a different statistic (sometimes called the “percentage difference� or “relative change� with a different base).

What if the previous month’s value is zero?

The formula is undefined because you cannot divide by zero. In that case, you cannot calculate a meaningful percentage. Report the absolute change (current − previous) or use a different metric, such as the change from the first non-zero month.

How do I interpret a 100% month-over-month increase?

A 100% increase means the current value is double the previous value. For example, going from 50 to 100 is a 100% increase. This is the same as saying the value grew by a factor of 2.

Related

• Date Duration Calculator: Days Between Dates
• Date Finder Calculator: How to Count Days
• Date Interval Calculator: How to Count Days

in a | Previous month value | units | 1000 | 0
in b | Current month value | units | 1150 | 0
out pct | Month-over-month change | % | ((b - a) / a) * 100 | 2
out diff | Absolute difference | units | b - a | 2