How to Forecast Dates in Excel with Useful Formulas

To extend a regular date schedule, add the interval to the previous date—for example, with a date in A2, enter =A2+7 in A3 to get the date one week later. For a date forecast based on a measured trend, use Excel’s FORECAST.LINEAR with dates as the values to predict and a period number or other numeric driver as the input. First decide whether you need to extend a schedule or estimate a date from data; these are different tasks.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The formulas below also work in current Excel for Mac and Excel for the web, though ribbon placement can differ slightly.
A column of real Excel dates, not dates stored as text. Select a date cell and check that the Number Format control shows a date format.
For a trend-based estimate, matching numeric input values for each date, such as week numbers, production counts, or elapsed days.
An optional list of holiday dates if the forecast should skip weekends and holidays.

Step-by-Step

Choose what you are forecasting. Use date addition for a known repeating schedule, such as a weekly report or a monthly payment reminder. Use FORECAST.LINEAR when you have paired observations and want to estimate a date for a particular value or period. A date is stored as a number in Excel, so Excel can calculate with it, but a trend forecast needs an appropriate numeric input column. If you actually want to forecast sales or another measurement across future dates, forecast the measurement; the dates are the timeline, not the forecast output.
Organize and check the historical data. Put dates in one column and any associated period numbers or measured inputs in another. Keep one observation per row, use consistent units, and sort records by date if you are reviewing a chronological series. Check a few cells by selecting them and looking in the formula bar. If a date is left-aligned or does not behave like a date in calculations, it may be text. Use Data > Text to Columns to convert text dates when needed, choosing the correct date order in the wizard; alternatively, re-enter the values using a format Excel recognizes. Make a copy before converting a large imported dataset.
Extend a schedule with a fixed number of days. With the first date in A2 and a weekly schedule, enter =A2+7 in A3, then fill the formula down using the fill handle at the lower-right corner of the cell. For a daily schedule, use =A2+1; for every 14 days, use =A2+14. Each result is the prior date plus the stated number of calendar days. This is the simplest approach when the gap is always the same number of days. If Excel displays a number such as 45686, the calculation may be correct: select the result cells and choose Home > Number Format > Short Date.
Extend a schedule by calendar months. Adding 30 days is not the same as moving forward one calendar month. With a starting date in A2, enter =EDATE(A2,1) in A3 to move one month ahead, then fill down. For every three months, use =EDATE(A2,3). EDATE keeps the result in the appropriate month and adjusts dates near month-end when that month has fewer days. For instance, advancing one month from January 31 returns the last valid day in February. Format the results as dates if they appear as serial numbers.
Skip weekends for working-day dates. If a task takes five working days from a start date in A2, enter =WORKDAY(A2,5) in the result cell. WORKDAY excludes Saturday and Sunday, but not public holidays. If holiday dates are listed in F2:F10, use =WORKDAY(A2,5,$F$2:$F$10) to exclude those dates too. The result is the date five working days after the start date; confirm your organization’s convention on whether the start day counts as day one. For weekends other than Saturday and Sunday, use WORKDAY.INTL and check its weekend argument against Excel’s function help.
Set up a trend-based date estimate. For a simple, checkable example, enter January 1, January 8, January 15, and January 22, 2025, in A2:A5. Enter the matching period numbers 1, 2, 3, and 4 in B2:B5, then enter 5 in B6. This represents a weekly series. With dates in A2:A5 and the matching period numbers in B2:B5, enter =FORECAST.LINEAR(B6,$A$2:$A$5,$B$2:$B$5) in C6. FORECAST.LINEAR estimates the date serial for period 5 from the linear relationship between period number and date. Here the intervals are consistently seven days, so the result is January 29, 2025. Format C6 as a date to see it clearly. The dollar signs keep the historical ranges fixed if you copy the formula.
Review the estimate before using it. Compare a trend-based result with the historical dates and the assumptions behind the input values. A linear forecast continues an average straight-line pattern; it does not know about holidays, seasonality, changing schedules, or a planned one-off delay. If the schedule follows calendar months rather than a constant number of days, use EDATE instead of a linear trend. If you are predicting a quantity such as sales for future dates, Excel’s Data > Forecast Sheet can create a time-series forecast of that quantity, but it does not forecast the dates themselves. On Mac or Excel for the web, ribbon labels or availability may vary; use the equivalent Forecast Sheet command if shown, or use worksheet formulas.

Common Mistakes

Using +30 for a monthly schedule. Calendar months have different lengths. A formula that adds 30 days will gradually move away from the same day of each month. Use EDATE when the intended interval is a month or a fixed number of months.

Forecasting without paired, meaningful data. FORECAST.LINEAR needs numeric known inputs and corresponding known outputs. If the input values are not in the same rows as their dates, the estimate can be misleading even when the formula returns a result. A period number is useful for a regularly spaced sequence; for irregular observations, use an input that accurately represents the relationship you want to model.

Confusing the forecasted value with its display. Dates are stored as serial numbers. A number in the result cell does not necessarily mean the formula failed; apply a date format. Conversely, formatting text as a date does not convert the text into a real date.

Assuming a forecast is a calendar or business rule. A trend line does not automatically avoid weekends, holidays, or closed periods. Use WORKDAY for working-day calculations, or explicitly adjust the forecast when a real scheduling rule requires it.

Tips

Label columns clearly, such as Date, Week Number, and Forecast Date, and keep input data separate from calculated results. This makes it easier to spot a mismatched range and to explain what the forecast means to someone else. Use an actual Excel date in the input cells, and choose a display style such as 29-Jan-2025 when ambiguity between day and month could cause confusion.

For a short repeating series, entering the first two dates and dragging the fill handle can extend a pattern. Check the first few results before filling hundreds of rows: Excel may infer a sequence from the selected cells, and the inferred interval may not match your intention. If you need formulas that update when the start date changes, use a formula rather than typing each future date manually.

Keep a copy of the original observations and record the assumptions behind a forecast, including the interval, excluded holidays, and selected historical range. For a trend model, charting the historical observations alongside the forecast can reveal an implausible jump. Treat a forecast as an estimate, not a promise of the actual date.

Troubleshooting

The result shows a five-digit number: select the result cell, then choose Home > Number Format > Short Date. If the cell already has a date format but shows an unexpected value, inspect the formula and its referenced cells.

The formula returns #VALUE!: one or more inputs may be text rather than numbers or valid Excel dates. Check for leading apostrophes, spaces, or inconsistent imported date formats. Convert the inputs to real dates and try again.

FORECAST.LINEAR returns an error or an implausible date: make sure the known date range and known input range have the same number of rows, and that all input values are numeric. Confirm the target input is on a sensible scale. A trend estimated from only a few points, or from data that curves or changes direction, may extrapolate poorly.

WORKDAY gives the wrong day: verify the start date, number of workdays, holiday range, and weekend convention. WORKDAY skips the start date when counting forward. If your organization uses a nonstandard workweek, use WORKDAY.INTL and configure its weekend pattern rather than trying to compensate by adding or subtracting days.

Frequently Asked Questions

Can Excel predict a future date from past dates?
Yes. For a numeric pattern or relationship, use FORECAST.LINEAR with dates as the known output values and matching numeric inputs, such as period numbers. For a known schedule, a date-addition formula is usually more appropriate and easier to maintain.

How do I forecast the same day each month?
Use EDATE from the previous date with a one-month interval. Month-end dates may be adjusted to the last valid day of the next month. If you specifically need every date to be the last day of a month, define that rule separately rather than assuming every month has the same number of days.

Can I forecast only business days?
Yes. WORKDAY calculates a date a specified number of working days from a start date and can exclude a supplied holiday list. Use WORKDAY.INTL when the weekend pattern differs from Saturday and Sunday.

Is Excel’s Forecast Sheet a date forecasting tool?
It forecasts values, such as sales, across a timeline of dates. It does not estimate a new date from a set of dates. Use date arithmetic, WORKDAY, or FORECAST.LINEAR depending on the scheduling question.

Why does Excel show a number instead of a date?
Excel stores dates as serial numbers and applies a number format to display them as dates. Apply a date format to the result cell. If changing the format has no effect, check whether the original input is text or whether the formula points to the intended cells.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.