Dueling Excel 97

Determine Quarter For column of Dates: CHOOSE or CEILING function?


See Mr Excel and excelisfun use two methods to create a formula that can take any date and determine what quarter it is. See one formula with CHOOSE, MONTH and YEAR or CEILING, MONTH and YEAR.


Be the first to comment

Leave a Reply