Function formula to convert quarter in excel
- angryTomOriginal
- 2019-11-05 09:57:278992browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Tutorial on using Excel symbol function signNext article：Tutorial on using Excel symbol function sign