So let me ask this, is there any easy way to have the spreadsheet tell me what the most "valuable" 12 month period is? text values) you never get a working spreadsheet.Īwesome! I love forums. Once you have the right cell values, the formatting is just a matter of taste. Number format: YYYY-MM or MMM YYYY or anything you like. How do I do that? Appreciate your help in advance! That would be cool.Īlso, I'd love to have a running number, as in maybe in the third column, each row shows me the total sum for the prior 12 months up to that row's date. some calculation that shows me "the highest sum of any 12 month (12 row) section is Sep 16 through Sep 17". What I'd really love is for some field somewhere in that document to show me the highest 12 month period, as in. I'll fill it out up until December 2017, current date. I'm doing to fill in some income I've made each month in the second column so it will look like "July 2016 - $20" for example, then below that row two will be "August 2016 - $40" and so on. I tried searching the "format cell" area but all it's giving me are specific days, how do I make each row one month?Īlso, now a slightly more complex question. I want each row to be a month of a year starting July 2016. I'm using a blank new OpenOffice spreadsheet document (like Excel)
0 kommentar(er)
