Get Quarter

The Planning Deskbook by John Mansfield http://pdbook.com/index.php/

=INT((MONTH(A1)+2)/3)

Here's my alternative.

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



© Copyright andrewsexceltips.net All Rights Reserved.