You don't need it when the start of the fiscal year is January 1st.

But it is required when the start of that fiscal year is a different month. And
I just modified my favorite formula <g.

"Rick Rothstein (MVP - VB)" wrote:

January-March is qtr 1
April-June is qtr 2
July-September is qtr 3
October-December is qtr 4

="FY"&YEAR(A1)&"-Q"&INT(1+MOD(MONTH(A1)-1,12)/3)

Maybe I'm missing something, but why do you need the MOD function in the
calculation for the quarter?

="FY"&YEAR(A1)&"-Q"&(1+INT((MONTH(A1)-1)/3))

Rick

--

Dave Peterson