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