I am trying to generate a formula that will use one cell whose contents will change daily, to predict a total amount by the end of the current month. I would like for this to a month to month formula, that is only for the current month. The layout of my sheet is: MONTH AMOUNT PREDICTION JAN 3730.3 FEB 3238.6 MAR 6082.4 The amount column looks to a different page that in turn pulls its data from yet another page. I would like for the prediction column to generate a number based on the average daily sales (amount/current day - 1)*number of days in current month. the -1 is because we pull data at midnight for the previous day. I thank you for your assistance.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Projection forecasting for monthly predictions

Thread starter Joeclupis
Start date Aug 11, 2018
Tags

amount current daily day month

Joeclupis

Board Regular

Aug 11, 2018

I am trying to generate a formula that will use one cell whose contents will change daily, to predict a total amount by the end of the current month. I would like for this to a month to month formula, that is only for the current month.

The layout of my sheet is:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]MONTH[/TD]
[TD]AMOUNT[/TD]
[TD]PREDICTION[/TD]
[/TR]
[TR]
[TD]JAN[/TD]
[TD]3730.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FEB[/TD]
[TD]3238.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MAR[/TD]
[TD]6082.4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The amount column looks to a different page that in turn pulls its data from yet another page. I would like for the prediction column to generate a number based on the average daily sales (amount/current day - 1)*number of days in current month. the -1 is because we pull data at midnight for the previous day.

I thank you for your assistance.