Quarterly Date Flash Fill

New Contributor

I wish Microsoft would develop quarterly Date flash fill for Excel, using similar logic to the as MM-YYYY date fill that is available for calendar months.  Over the years, I have wasted countless hours creating homebrew shortcuts so that Q1,Q2,Q3,Q4 would repeat going out several years.  Also having QQ-YYYY repeatable format would be tremendous time saver.  

 

Just a thought for Finance & Accounting professionals.

 

2 Replies

@DaveGorcyca 

="Q"&IF(MOD(ROW(),4)=0,4,MOD(ROW(),4))&"-"&2023+QUOTIENT(ROW()-1,4)

An alternative for Flash Fill could be this formula.

quarterly date.JPG 

The best way I tackle the problem is importing that to a Custom Sort List. Just would like to have this as a universal default in Excel. Having QUARTER(XX) function, based on the date field, just like MONTH, YEAR, etc.