Determining the Quarter When preparing sales reports, I have 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.