ExcelBanter - Formatting cell to show current Quarter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formatting cell to show current Quarter (https://www.excelbanter.com/excel-worksheet-functions/186417-formatting-cell-show-current-quarter.html)

S trainer

Formatting cell to show current Quarter

How can I format a cell to display the current quarter?

David Biddulph[_2_]

Formatting cell to show current Quarter

How do you define quarters? In what format do you want the answer to
appear?

Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3)
--
David Biddulph

"S trainer" wrote in message
...
How can I format a cell to display the current quarter?

S trainer

Formatting cell to show current Quarter

Thanks David! This is exactly what I needed

"David Biddulph" wrote:

How do you define quarters? In what format do you want the answer to
appear?

Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3)
--
David Biddulph

"S trainer" wrote in message
...
How can I format a cell to display the current quarter?

All times are GMT +1. The time now is 05:17 AM.