GET_RUN_RATE_CURRENT_MONTH
Project the month-end total based on current progress so far.
=GET_RUN_RATE_CURRENT_MONTH(valueToDate, [dayOfMonth])Gibt zurück: number
Übersicht
GET_RUN_RATE_CURRENT_MONTH calculates a projected month-end total by extrapolating from the value accumulated so far this month. It takes the value you have achieved to date, determines the daily rate based on how many days have passed, and multiplies by the total number of days in the current month to estimate the final total.
Parameter
| Parameter | Typ | Erforderlich | Beschreibung |
|---|---|---|---|
valueToDate | number | Ja | The cumulative value achieved so far this month. |
dayOfMonth | number | Nein | The current day of the month. Defaults to today's date if omitted. |
Beispiele
Project monthly revenue from mid-month data
With $15,000 in revenue by day 15, project the full-month total (assumes 30-day month).
=GET_RUN_RATE_CURRENT_MONTH(15000, 15)Ausgabe
30000Auto-detect today for traffic projection
Project monthly page views from 5,000 views to date, using today's date automatically.
=GET_RUN_RATE_CURRENT_MONTH(5000)Ausgabe
15000Early-month signup projection
With 300 signups in the first 5 days, estimate the month-end total (31-day month).
=GET_RUN_RATE_CURRENT_MONTH(300, 5)Ausgabe
1860Late-month sales forecast
With $42,000 in sales by day 25, project the month-end figure (30-day month).
=GET_RUN_RATE_CURRENT_MONTH(42000, 25)Ausgabe
50400Support ticket volume projection
With 180 support tickets by day 10, project the total monthly ticket volume.
=GET_RUN_RATE_CURRENT_MONTH(180, 10)Ausgabe
558Anwendungsfälle
Revenue forecasting
Project end-of-month revenue from current sales to date for cash flow planning and stakeholder reporting.
Marketing campaign tracking
Estimate whether a campaign will hit its monthly lead or conversion target based on mid-month performance.
SaaS metrics dashboard
Project monthly active users, signups, or MRR from partial-month data on a real-time dashboard.
Content production tracking
Estimate whether the content team will meet their monthly article quota based on progress to date.
Support ticket volume planning
Project total monthly support tickets to plan staffing needs for the remainder of the month.
Profi-Tipps
The projection becomes more accurate as the month progresses. Use with caution in the first week of the month.
Compare the projected total with your monthly target to assess whether you are on track: =GET_RUN_RATE_CURRENT_MONTH(B5) / target.
Feed the result into GET_RUN_RATE_NEXT_MONTH to project forward with a growth rate applied.
Omit the dayOfMonth parameter for a formula that automatically updates every day without manual input.
Track the projected value over time by recording it daily -- this shows whether your trajectory is improving or declining within the month.
The function accepts two parameters: the cumulative value achieved so far and an optional day-of-month override. If the day is not specified, the function automatically uses today's date to determine the current day and the total days in the month. This auto-detection makes the formula maintenance-free -- it updates its projection every day as the month progresses.
The run rate calculation is a fundamental forecasting technique used across business contexts. It assumes that the rate of progress observed so far will continue for the remainder of the month. While this is a simplification (real metrics often have weekly patterns, seasonal effects, or non-linear trends), it provides a useful baseline estimate that gets more accurate as the month progresses.
This function is most accurate in the latter half of the month when there is more data to base the projection on. Early in the month, projections can be volatile because a single good or bad day has an outsized impact on the daily rate. For projecting the following month with growth adjustments, use GET_RUN_RATE_NEXT_MONTH. For converting weekly data to daily averages as a preprocessing step, use GET_AVG_DAILY_TRAFFIC_FROM_WEEK.
Häufige Fehler
Error: Numeric value requiredUrsache: The valueToDate parameter is not a number or references a cell with text.
Lösung: Ensure valueToDate is a numeric value. If referencing a cell, verify it contains a number, not text formatted as a number.
Error: Invalid day of monthUrsache: The dayOfMonth parameter was set to 0 or a negative number.
Lösung: Provide a positive integer between 1 and 31 for dayOfMonth, or omit it entirely to use auto-detection.
Projection seems unrealistically high or lowUrsache: It is very early in the month and the daily average is skewed by a single outlier day.
Lösung: Wait until at least day 7-10 for more stable projections. Alternatively, use a manual average that accounts for known patterns.
Häufig Gestellte Fragen
The formula is: (valueToDate / dayOfMonth) * daysInMonth. It calculates the daily rate from current progress and multiplies by the total days in the month.
No, the projection assumes uniform daily distribution. It does not adjust for weekday/weekend patterns, holidays, or seasonal variations. The estimate is a simple linear extrapolation.
The projection on day 1 simply multiplies the first day's value by the number of days in the month. This can be highly inaccurate, as one day of data is not representative. The projection becomes more reliable as the month progresses.
When dayOfMonth is not provided, the function uses today's date to determine both the current day and the total days in the current month. It correctly handles months of 28, 29, 30, or 31 days.
The function is designed for monthly projections specifically, as it uses calendar month day counts. For other time periods, you would need to perform similar calculations manually.
Yes, the projected value is rounded to the nearest whole number.
The function returns "Error: Invalid day of month" for values of 0 or below. The day must be a positive integer.
Verwandte Funktionen
Beginnen Sie noch heute mit GET_RUN_RATE_CURRENT_MONTH
Installieren Sie Unlimited Sheets, um GET_RUN_RATE_CURRENT_MONTH und 41 weitere leistungsstarke Funktionen in Google Sheets zu erhalten.
