Thread: Dates in a Financial Year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson Sam Wilson is offline
external usenet poster
  
Posts: 523
Default Dates in a Financial Year

If you have a date in A1:

="Qtr"&INT((IF(MONTH(A1)<8,MONTH(A1)+5,MONTH(A1 )-7)-1)/3)+1&" " &
IF(MONTH(A1)<8,YEAR(A1)-1,YEAR(A1))

"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