Re: Group data by UK financial years

Tech-Archive recommends: Fix windows errors by optimizing your registry

Tony,

As far Fiscal Years are concerned, you could adapt
your own UDF based on the following one :

Function FY(dDate As Date) As String

Select Case Month(dDate)

Case 6, 7, 8: FY = "Q1 " & "FY" & Year(dDate) + 1

Case 9, 10, 11: FY = "Q2 " & "FY" & Year(dDate) + 1

Case 12: FY = "Q3 " & "FY" & Year(dDate) + 1

Case 1, 2: FY = "Q3 " & "FY" & Year(dDate)

Case 3, 4, 5: FY = "Q4 " & "FY" & Year(dDate)

End Select
End Function

Hope this clarifies

Cheers
Carim

.

Relevant Pages