Date format in Header of Table

[#1]

I am trying to get the header in the table to say Mar 2013, but when I use the following formula I get the date number.

$(=max(MonthName(CalendarWrittenDate))) Sales

See attachment

[CELAMBARASAN · Accepted solution]

You have to use in reverse

$(=MonthName(max(CalendarWrittenDate))) Sales

Max() return numbers only.

Hope it helps

Celambarasan

[#3]

Worked Great, THANKS