Calculate Quarter Number In Excel

By
John Dalesandro
– February 17th, 2009Posted in: Computing

To calculate the quarter number for a given date (A1) in a regular calendar year, enter the following formula:

=ROUNDUP(MONTH(A1)/3,0)

Tags:

About John Dalesandro

My name is John Dalesandro and I am a software engineer based in New Jersey. My experience covers all aspects of the software development life cycle with a primary focus on enterprise web applications.