Hello,

Have calendar quarter (1-4) in one column, have month serial value in the other (1-12). How do I caculate with month of the quarter that the date is?

so for
december

month serial = 12
quarter = 4
month of quarter = 3

because december is the 3rd month of that Quarter.

I would like a formula that can determine that.

Any ideas?