Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have to use in reverse
$(=MonthName(max(CalendarWrittenDate))) Sales
Max() return numbers only.
Hope it helps
Celambarasan
You have to use in reverse
$(=MonthName(max(CalendarWrittenDate))) Sales
Max() return numbers only.
Hope it helps
Celambarasan
Worked Great, THANKS