| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates in a Financial Year | Excel Worksheet Functions | |||
| Financial Year Weeknum | Excel Discussion (Misc queries) | |||
| year quarters === Financial Year | Excel Discussion (Misc queries) | |||
| HOW TO FORECAST VALUES FOR NEXT YEAR | New Users to Excel | |||
| Moving data in financial forecast | Excel Worksheet Functions | |||
Hybrid Mode
