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...
 
Back
Top