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 2004 - 2010, andrewsexceltips.net All Rights Reserved.