How to Find a Quarter Corresponding to a Date in Excel

Submit Your Tip

How to Find a Quarter Corresponding to a Date in Excel – This is a place for the community to provide tips and advice on How to Find a Quarter Corresponding to a Date in Excel. This topic was created by Mary Farley and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Tip 1 - How to Find the Quarter Corresponding to a Date in Excel | eHow

Published: 9 years, 6 month(s) ago | Submitted by key 3net 152980 | permalink

Microsoft Excel 2013 lacks a function for extracting the quarter from a given date, but you can overcome that limitation with some code. By combining the Month and Roundup functions, along with some simple arithmetic, you can force Excel to calculate the calendar or fiscal quarter number from any referenced or directly entered date.

For further reading: http://www.ehow.com/how_6158706_quarter-corresponding-date-excel.html ^[1]