Hello,
I have monthly data that spans across 5-6 years. I need the forecast function to recognize that Line 2 started accruing patients in April 2021, so begin forecasting here for July 221, Line 2 began forecasting in May 2021, so begin here, and so on. I am trying to have a consistent formula across all cells in the table so there is less manual adjustment month-to-month, which is currently a lot. If I were to use the forecast function as it stands today, it will run from July, 2015 and will not give accurate forecasting for July, 2021 (since the cells are blank). I've found that using either data completion option does not assist. Does anyone know how I can do this?
I have monthly data that spans across 5-6 years. I need the forecast function to recognize that Line 2 started accruing patients in April 2021, so begin forecasting here for July 221, Line 2 began forecasting in May 2021, so begin here, and so on. I am trying to have a consistent formula across all cells in the table so there is less manual adjustment month-to-month, which is currently a lot. If I were to use the forecast function as it stands today, it will run from July, 2015 and will not give accurate forecasting for July, 2021 (since the cells are blank). I've found that using either data completion option does not assist. Does anyone know how I can do this?
| April 2021 | May 2021 | June 2021 | July 2021 |
| 1 | 2 | 3 | Forecast |
| 1 | 2 | Forecast | |
| 1 | Forecast |
