Dueling Excel 97


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

DESCRIPTION

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.

WORKBOOKS