Formula to number months within a quarter?
Within Q1, January is the first month (1), February the second (2), March the (3rd). Then Q2 starts, and April is the first (1), May is the second (2), and so on.
Is there a good way to set something like this up?
I ask because I want to build an IF AND statement, in which IF a value exists within a cell AND that cell is #2 within that quarter, a cell will be populated.