Thread: Dates in a Financial Year
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Dates in a Financial Year
With your date in cell A1; try the below formula

="Qtr"&LOOKUP(--TEXT(A1,"mm"),{1,2,5,8,11},{2,3,4,1,2}) & TEXT(A1," yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

If I have a financial year August01-July31, is there a worksheet function(s)
which I can use to convert date such as 22/08/09 to read 'Qtr1, 2009' or
23/03/10 to read 'Qtr 3, 2009' etc. Any advice?
Reply With QuoteReply With Quote