Fiscal Year and Quarter

[JohnC]

This fantastic expression was posted by Duane Hookom. I have no idea how it
works but it displays the fiscal year and quarter for FY starting on October
1.

=Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0)

It displays the first quarter for FY 2007 as Q1 2007.

However I would like to display this as 2007 Q1. I couldn't get this to
work.

JohnC

 

[tina]

try

=Format$(DateAdd("q",1,Date()),"yyyy"" Q""q",0,0)

or

=Format$(DateAdd("q",1,Date()),"yyyy \Qq",0,0)

hth

 

[J. Goddard]

Try =Format$(DateAdd("q",1,[Onset Date]),"yyyy \Qq",0,0)

John