Just wanted to thank you both so much for providing your solutions below. I
can't tell you how grateful I am for your sharing of knowledge.
"Dave Peterson" wrote:
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