Function formula to convert quarter in excel

Excel function formula to convert to quarter

Sometimes we want to convert the date to quarter for display, such as 1996 July 4th is shown as Q3 1996. Let’s see how to achieve it.

There is such a data table, column A is the date

Enter or copy and paste the following formula in B2

=YEAR(A2)&"年第"&CEILING(MONTH(A2)/3,1)&"季度"

or

=YEAR(A2)&"年第"&INT((MONTH(A2)+2)/3)&"季度"

Just drop down and fill in.

Recommended tutorial: excel tutorial

The above is the detailed content of Function formula to convert quarter in excel. For more information, please follow other related articles on the PHP Chinese website!