Determining the quarter

When preparing sales reports, I often used quarters as units of time. Particularly helpful in joint-stock companies, where a quarterly financial and operating report should be prepared. I will show you how you can ask Excel to provide us with this information.

Let's assume that we store particular dates in column A.

Function structure:

= CEILING (MONTH (A1) / 3,1)

Formula analysis:

First, I take the date from cell A1 and divide the obtained month number (because a quarter has 3 months). Next, the rounding up function comes to our aid, which will take our month number depending on the result of dividing, e.g. we have month 11, divided into 3 and the result will be 3.66 - after applying the round up function we will get quarter 4.