Formatting cell to show current Quarter

  • Thread starter Thread starter S trainer
  • Start date Start date
Thanks David! This is exactly what I needed

David Biddulph said:
How do you define quarters? In what format do you want the answer to
appear?

Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3)
Click to expand...
 
You must log in or register to reply here.

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

Quarterly inputs 2
I want quarters not months 5
How to equal a cell in another worksheet incl fill colour 3
If statement with generic value 5
trouble with closed workbook 2
Return the current Yearly Quarter based on date 2
problem with linked workbook 1
Excel EXCEL 2003: Format cells for previous quarters 0

Back
Top