Excel

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

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