TB's Code Library
If it ain't tight, it ain't right!
Search
Tuesday, April 19, 2011
Excel - Current Quarter Calc
Excel Formula to Calculate the Current Quarter
=IF(LEN(B2) > 0,VLOOKUP(MONTH(B2),{1,"Q1";4,"Q2";7,"Q3";10,"Q4"},2),"") & IF(LEN(B2)>0,IF(OR(MONTH(B2)=1,MONTH(B2)=2)," '" & RIGHT(YEAR(B2),2)," '" & RIGHT(YEAR(B2),2)),"")
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)