View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kurt Kurt is offline
external usenet poster
 
Posts: 47
Default Dates in a Financial Year

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?