Quarter format date

  • Thread starter Thread starter Alberto
  • Start date Start date
A

Alberto

I'm working with dates and I want to see which quarter the
date is from.
Is there a date format to see quarters?
 
No but you can use formulas, with the date in A1
use this formula for a quarter that starts with the new year

="Q"&INT((MONTH(A1)+2)/3)

and this as an example with a quarter that starts with April 1st

="Q"&INDEX({4;1;2;3},INT((MONTH(A1)+2)/3))
 
Not sure on formatting, but you could use a formula in
another cell:

="Q"&CEILING(MONTH(A1),3)/3

HTH
Jason
Atlanta, GA
 

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

date into current and previous quarters 3
Conditional Formatting End of Quarter 7
Quarterly Formula 1
Calculate a quarter 16
If cell = now – current Qtr – 28 days then RED 3
Change quarters in Pivot table when grouping 1
Still trying to average 4 worksheets and having formula problems 3
How to distribute/spread/map cost of project across different year 3

Back
Top