1 Reply Latest reply: Apr 15, 2013 9:21 AM by Sandro Pividori RSS

    Referring to Current month, previous month, and the month before

      Hey guys,

       

       

      I had a doubt which i hope you guys will be able to solve for me.

       

       

      I refer to the current month name in my text code as : =Monthname(max(MonthName))   >> This returns April as value.

       

      The previous month is referred to as : =Monthname(max(MonthName)-1)  >> This returns March as value.

       

       

      However, i want to display the month name before that (to show data for 3 months). So I tried =Monthname(max(MonthName)-2). ------ But for some reason it still returns the month name - March------

       

       

      Could someone tell me where i'm going wrong? Thanks a ton! =)