If you put a real date in B2 (you can format it as mmmyy), then you can use

=IF(MONTH(B2)+3=COLUMN()-1,TEXT(DATE(YEAR(B2),MONTH(B2)+3,1),"mmmyy"),"")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"martins" wrote in
message ...

hi

can anyone help; I have a spreadsheet which lists the clients within
our business and the month that they are due to be visited - The client
name is in column a1 followed by 12 columns representing the months of
the year b1-m1: at present, to record that a visit is due, the month is
manually entered in the approriate columns b1-m1 for example as "jan06"
in column b1; it is usually the case that a further visit will be due
in 3 months therefore, my question is this: I would like a formula that
will autumatically return "apr06" in cell e1 if "jan06" is entered in
cell b1 - i would like to show this in the format described and not as
a number -

Sorry if it sounds confusing - but can anyone help?


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