# Thread: Simple determination for Quarter Number (Excel 2000)

1. ## Simple determination for Quarter Number (Excel 2000)

I have to choose a rate based on the quarter a date falls in. I didn't find in Search any simple way to convert a Date (Date Placed in Service) to a Quarter number. I was hoping to do a Choose function for the rate based on the quarter. Would this be a good approach? Thanks.

2. ## Re: Simple determination for Quarter Number (Excel

With the date in cell A1 the following results in 1 for January-March, 2 for April-June etc
<code>=INT((MONTH(A1)+2)/3)</code>

3. ## Re: Simple determination for Quarter Number (Excel 2000)

That's great! Thanks.

4. ## Re: Simple determination for Quarter Number (Excel 2000)

If the date is in A1, then:

<pre>=INT((MONTH(A1)-1)/3)+1
</pre>

Edited by Legare Coleman to fix an error in the formula

5. ## Re: Simple determination for Quarter Number (Excel 2000)

Or

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•