Hi,
I see you have that formula in a new column immediate to right of my date column. if I copy that to my date column I get Sep-71 when I type sept 1972, and I get 15 apr 69 if I type a full date 15 April 1969. the formulA ceases to exist in the cell just typed in,as well it might as I have then superceded it. It needs to pull the data in from the date column.
It is giving me a year 1969 or a month year Sept 1971 or a full date 23 Nov 1991 so thats working.

How can I have this so I havent a third column as its made the data 3 columns wide per subject now., and I have two columns with dates in so a double vision confusion going on.


DBenz