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.