• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

financial Qtrs

lesleylkp

New Member
Hi awesome lot :) I found a formula for adding Quarters from dates, but unfortunately it calculates based on Jan - Dec. Does anyone know a formula which will do it by Financial Quarters from dates as in - April to March?? this is the formula I have - =YEAR(J3)& " Q" & INT(MONTH(J3)/4)+1

many thanks x
 

Peter Bartholomew

Well-Known Member
Given a four-digit year 'yyyy', a month number 'm' and the first month of the financial year 'm0',
= (yyyy - (m<m0)) & " Q" & (1 + MOD(FLOOR(m-m0, 3)/3, 4))
gives the quarter, identified by the year in which Q1 occurred.
 
Top