Grouping by quarter with specific dates

I’m using the below formula to group by quarter. How do I change the dates they are using to determine the quarters? For example, our quarter 3 ended on 9/27, however the formula is including everything through 9/30 in quarter 3.
CONCATENATE(“Q”,DATETIME_FORMAT({Invoice sent date}, “Q”)," ",YEAR({Invoice sent date}))

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.