I have a spreadsheet with the following columns


January 06 February 06 March06 April06 May06 Etc
Jan-06 Apr-06
Jan-06
Feb-06 May-06


I would like to create a spreadsheet that automatically returns the
month based on a 3month cycle e.g. enter Jan-06 and Apr06 automatically
returns in the April 06 column enter Feb06 and May06 auto fills in May
column, and so on - (the spreadsheet is based on a 12 month cycle)

Can anyone provide the formula for this

Many Thanks


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=524041