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! =)