Hi,

Hoping one of you geniuses can help me. I have a column of dates in DD/MM/YYYY format and I want to (in another column) change them to text so I just show MMYYYY. Any ideas?

Also, whilst I am here, does anyone know how to count occurrences of a particular date (by month). ie. if I have all the days in 2006 listed in a column, how would I count how many days fall in a particular month?

Many thanks in advance,

GW