Mar 09 2023 06:51 AM
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.
Mar 09 2023 07:04 AM
="Q"&IF(MOD(ROW(),4)=0,4,MOD(ROW(),4))&"-"&2023+QUOTIENT(ROW()-1,4)
An alternative for Flash Fill could be this formula.
Mar 09 2023 07:37 AM