In this article, I will show you how to calculate the quarter of a certain day in Excel.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to calculate quarter in Excel
1. Enter the formula shown below.
Explanation: ROUNDUP(x, 0) always rounds x to the nearest integer. The MONTH function returns the number of months in a date. In this example, the formula would be =ROUNDUP(5/3.0), =ROUNDUP(1.666667.0), 2. May is in Q2.
2. See if this formula works for all months.
Explanation: now it is not difficult to see that the first three values (months) in column B are rounded to 1 (Q1), the next three values (months) in column B are rounded to 2 (Q2 ),..
In addition, you can also view many other excel articles here.