Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am presenting data by quarter, with the labels generated by formula. I would like to add text after it displays the quarter. Here is one of the labels:
=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0))
This displays the current quarter, but I would like to add the text 'Listings' after it. Can anyone help?
=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0)) & ' listings'
Hi,
Try you made a table box whit only field listed?. i think that would be good.
=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0)) & ' listings'
Thanks. How can I format QuarterName to show 1Q12, instead of Jan-Mar 2012?
Hi,
Try this
=Ceil(Month(Today())/4) & 'Q' & Right(Year(Today()), 2)
Regards,
Jagan.