To calculate the quarter number for a given date (A1) in a regular calendar year, enter the following formula:
1 | =ROUNDUP(MONTH(A1)/3,0) |
Technology to get things done
To calculate the quarter number for a given date (A1) in a regular calendar year, enter the following formula:
1 | =ROUNDUP(MONTH(A1)/3,0) |