Hello Ldyflyr

Today’s date in cell A1, then paste each formula in cells A2, B2, and
C2 respectively.

="Period "&CHOOSE(MONTH(A1),10,11,12,1,2,3,4,5,6,7,8,9)
="Period "&CHOOSE(MONTH(A1),9,10,11,12,1,2,3,4,5,6,7,8)
="Period "&CHOOSE(MONTH(A1),8,9,10,11,12,1,2,3,4,5,6,7)

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=533542