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

Published  | Submitted by key 3net 152980
How to Find the Quarter Corresponding to a Date in Excel | eHow

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.

About Author

More by key 3net 152980

About This Tip

Posted: 9 years, 6 month(s) ago

70 Reads
0 Votes