Thread: Fiscal Year Calculation
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Fiscal Year Calculation
Ok, here's an amended formula which does take account of leap years:

=YEAR(A1-151-INT((YEAR(A1)-2000)/4))-1999

Hope this helps.

Pete

Reply With QuoteReply With Quote