Return the current Yearly Quarter based on date

H

hozman

Side Bar** This discussion board is a great resource thanks for the
information.

I am trying to figure out a formula that will return a 1st Quarter, 2nd
Quarter, etc. in to a field based on todays date. Assuming each Quarter began
on the first of Jan, Apr, Jun, and Oct.

So if today was January 3, it would place 1st quarter in the field. If it
was April 12 it would place 2nd quarter in the field, etc.

Thanks!!!
 
P

Per Jessen

Hi

Try this:

=CHOOSE(ROUNDUP(MONTH(TODAY())/4;0),"1st Quarter", "2nd Quarter","3rd
Quarter","4th Quarter")

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for returning quarter based on current date? 4
Quarter function based on current date 1
End of Quarter Based on Fiscal Year 2
Still trying to average 4 worksheets and having formula problems 3
Calculating quarters of a year. 4
How can I begin year/1st quarter in July instead of Jan in Access 1
Date query 4
How should I get the # of quarters in a year. 12

Top