To get the financial quarter use
=CHOOSE(INT((MONTH(A1)+2)/3),3,4,1,2)
To get the financial year use
=IF(MONTH(A1)<7,YEAR(A1)-1 &"-"& YEAR(A1),YEAR(A1) &"-"&YEAR(A1)+1)
Let me know if you have any alternatives.
Sunday 11 September 2011
Financial Date Formulas
Here are some financial date formulas that may come in handy.
To get the financial quarter use
To get the financial year use
Let me know if you have any alternatives.
To get the financial quarter use
To get the financial year use
Let me know if you have any alternatives.
Subscribe to:
Posts
(
Atom
)
