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:
<tbody>
</tbody>
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.
The layout of my sheet is:
MONTH | AMOUNT | PREDICTION |
JAN | 3730.3 | |
FEB | 3238.6 | |
MAR | 6082.4 |
<tbody>
</tbody>
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.