Determine Quarter for Fiscal Calendar Months

**John Bates** · 10-24-2009, 01:26 PM

Hi,

Our fiscal calendar year is from Nov 1 (Q1) to Oct 31 (Q4). If I have a column of cells with each cell containing a date of the year, do you know of a way for me to be able to determine which quarter a particular date falls into? See the attached workbook for an example.

Thanks so much!
John

**darkyam** · 10-24-2009, 05:29 PM

Try =ROUNDUP(MOD((MONTH(C3)+2),12)/3,0)

**Teethless mama** · 10-24-2009, 05:57 PM

Originally Posted by john bates

hi,

our fiscal calendar year is from nov 1 (q1) to oct 31 (q4). If i have a column of cells with each cell containing a date of the year, do you know of a way for me to be able to determine which quarter a particular date falls into? See the attached workbook for an example.

Thanks so much!
John

=mod(roundup((month(c3)-1)/3,0),4)+1