Auto return month as text date

  • Thread starter Thread starter martins
  • Start date Start date
M

martins

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 th
month based on a 3month cycle e.g. enter Jan-06 and Apr06 automaticall
returns in the April 06 column enter Feb06 and May06 auto fills in Ma
column, and so on - (the spreadsheet is based on a 12 month cycle)

Can anyone provide the formula for this

Many Thank
 
One way:

D2: =IF(A2<>"", TEXT(DATE(2006,COLUMN(),1),"mmm-yy"),"")

Copy D2 to L2, then D2:L2 down as far as required.

Of course, this assumes that if the April column is filled out, then the
July column will display Jul-06, so if Jan-06 is entered, Apr-06 will be
displayed along with Jul-06 and Oct-06
 
Back
Top