ExcelBanter - forecast a financial value at year end

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - forecast a financial value at year end (https://www.excelbanter.com/excel-worksheet-functions/250590-forecast-financial-value-year-end.html)

Jock

forecast a financial value at year end

Cell J3 displays the total values listed in all columns on the sheet. When
another value is added to any column, J3 reflects this.
Now, to manually predict what J3 will say at year end (Dec 31st) ie an
estimate, I can simply divide J3 by the number of days passed (since Jan 1st)
and multiply by 365. This will be close enough for my purposes.
How can I put this into a formula?

Thanks
--
Traa Dy Liooar

Jock

Brad Autry

forecast a financial value at year end

=J3/(TODAY()-"01/01/2009")*365

"Jock" wrote:

Cell J3 displays the total values listed in all columns on the sheet. When
another value is added to any column, J3 reflects this.
Now, to manually predict what J3 will say at year end (Dec 31st) ie an
estimate, I can simply divide J3 by the number of days passed (since Jan 1st)
and multiply by 365. This will be close enough for my purposes.
How can I put this into a formula?

Thanks
--
Traa Dy Liooar

Jock

All times are GMT +1. The time now is 07:57 PM.