Sep 2, 2010 #1 Kivairu MIS Joined Mar 18, 2009 Messages 106 Location KE I want to name previous periods in the same year in text. Such that I have January,February,March. Anyone knows how to do this?
I want to name previous periods in the same year in text. Such that I have January,February,March. Anyone knows how to do this?
Sep 2, 2010 #2 ettienne Programmer Joined Oct 29, 2005 Messages 3,389 Location US =Text(FR("End"),"MMMM") Upvote 0 Downvote
Sep 2, 2010 Thread starter #3 Kivairu MIS Joined Mar 18, 2009 Messages 106 Location KE @Ettiene.Thanks for that but how do i show last month? Upvote 0 Downvote
Sep 2, 2010 #4 ettienne Programmer Joined Oct 29, 2005 Messages 3,389 Location US =FRFISCAL("End",YEAR,Period) Upvote 0 Downvote