How to create a Quarter formula in Excel

How to create a Quarter formula in Excel

by | Jul 10, 2018 | Excel Tips & Tricks

There is no specific Quarter formula in Excel. But an Excel quarter formula can be constructed by combining ROUNDUP and MONTH functions with custom number formatting. Syntax =ROUNDUP( MONTH( date value ) /3, 0 ) Steps Start with =ROUNDUP( function Continue with MONTH(...