In this formula, is there a way to change it to a fiscal year, being from
April to March (Apr, May, june being Q1)
And is there a way to have the year first folowed by the Qs?
Thank you

"Gary''s Student" wrote:

With a date in A1:

=ROUNDUP(MONTH(A1)/3,0) & "Q" & RIGHT(YEAR(A1),2)


--
Gary''s Student - gsnu200786