How to indicate the current month?

[richnorris]

Hi, I am trying to show on a pivot a list of months for the last two years, but I want to be able to show as the name of the current month 'MonthName - MTD' to indicate it is not a full month. I've been hacking around with it for a while, and I got something like

=Month & if(Month = Date(Today(), 'MMM'), ' -MTD')

to work, but then the sort order of the months fails. Is there a way to manually then sort the months?

Thanks!

[#2]

Hi,

If you can pad year/month ..then displaying the same in pivot table is easy ..you can sort the same numerically ...for eg. 201001, 201002, ...........200912,200910...

rgds

tapas

[richnorris]

Thanks, but its a business requirement that it shows years, broken down into months in the format 'MMM' with the current month showing as 'MMM - MTD'.