I have a formula field (text) on my opportunity object (Timing_c) and would like it to display which quarter the date in CloseDate field is.
If opportunity CloseDate = 25/09/2017, then display "Q3 2017" in Timing_c
Or is there a simpler way of doing this?
Thanks in advance!
8 answers
Try this Formula for formula field :
'Q'+IF(MONTH( CloseDate )<=3,'1',IF(MONTH( CloseDate )>3 && MONTH( CloseDate ) <=6,'2',IF(MONTH( CloseDate )>6 && MONTH( CloseDate ) <=9,'3',IF(MONTH( CloseDate )>9 && MONTH( CloseDate ) <=12,'4',''))))+' '+TEXT(YEAR(CloseDate))
Thanks.
