I need to have the ledger page produce a line that has yearly projection. This would be based on the monthly income summed and averaged projected 12 months.
I need to have the ledger page produce a line that has yearly projection. This would be based on the monthly income summed and averaged projected 12 months.
Last edited by richbauer; 01-18-2019 at 11:44 PM.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I think I got it so it makes sense.
You can use max(d11:d30) - min(d11:d30) to get number of days. Divide by 30 to get months and then use that in formula. Format max and min cells as dates. Solution as number.
Last edited by dweingar; 01-19-2019 at 12:45 AM.
Assume that you will count 5 for Jan to May
E5
=E2/(MMULT(MONTH(AGGREGATE({14,15},6,D11:D99,1)),{1;-1})+1)
Or if you list date bill for the different years.
=E2/(MMULT(MONTH(AGGREGATE({14,15},6,D11:D99,1))+YEAR(AGGREGATE({14,15},6,D11:D99,1))*12,{1;-1})+1)
Thanks Bo, this is what I got when I plugged in your top formula:
Please see attached
what did I miss?? Thanks that seems to be it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks