Software

How to calculate quarterly values in Excel

Quarterly Excel value expression

Excel doesn't have a built-in format that displays where a date falls into the quarter system. If you need a date's quarter, use the following expression:

=INT((MONTH(cellreference)-1)/3)+1

Since the expression both subtracts  and then adds 1, you might think you can eliminate both steps, but you can't. The expression can't handle the last month in each quarter.

3figa.jpg

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox