title: How to identify with a formula in excel if it is the 1st 2nd 3rd month in quarter?
body: <p>I'm trying to find a formula to identify if a month it is the 1st 2nd 3rd month in quarter</p>
  <p>I tried with MOD(MONTH(A1),3), but the 3rd month in the quarter is shown as zero</p>
  <p><a href="https://i.stack.imgur.com/LjESd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LjESd.png" alt="enter image description here" /></a></p>
  <p>I can use a condition where IF(MOD(MONTH(A1),3)=0,3,MOD(MONTH(A1),3)), but I'm wondering if there is something a bit more straightforward.</p>