Formula for Calendar Quarter

G

Guest

What is the formula to indicate the quarter for a given date (say in cell A1)
e.g. 25-Apr-06 = 2, 4-Jul-06 = 3, 1-Oct-06 = 4.
Thank you
 

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

Calculation of Quarter 16
Functions/formula 7
Return the current Yearly Quarter based on date 2
Find longest consecutive winning streaks 7
Payroll calculation 2
Dont know Excel Function 1
Date query 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Top