I was sure I had a mean to retrieve the relative quarter of a date, just cannot find the sheet again and looking in the date functions there is none that does just that. I need to retrieve the relative quarter of a given date, so 1~4 depending where the date falls; I’m not sure how I achieved this in the past but possibly was a formula or a set of formulas?
Hello,
use: =INT((MONTH(A1)-1)/3)+1 (assuming your date is in A1) to get the number of the quarter.
Hope that helps.
If the answer helped to solve your problem, please click the check mark (
) next to the answer.
If you need it for display, maybe just format your date using Q (QQ) format code? Using TEXT spreadsheet function, you may get the value as text.