Aug 27, 2009 #1 coachvi Technical User Nov 19, 2008 111 GH how can i edit this to display my income statement for each month =TEXT(FRFISCAL("End",IF(FR("Period","U")>1,FR("Year"),FR("Year")-1),IF(FR("Period","U")>1,FR("Period","U")-1,FR("Period","U")-1+12)),"mmmm")
how can i edit this to display my income statement for each month =TEXT(FRFISCAL("End",IF(FR("Period","U")>1,FR("Year"),FR("Year")-1),IF(FR("Period","U")>1,FR("Period","U")-1,FR("Period","U")-1+12)),"mmmm")
Aug 27, 2009 #2 ettienne Programmer Oct 29, 2005 3,388 US You can edit it in Excel. Upvote 0 Downvote