the datas are in the following format:
Day.Monty.Year (24.22.08) -> all dates are from 2008, German format
I want them to be converted into:
0 for Dates between 01.01.08 to 28.02.08 + 01.12.08 - 31.12.08
1 for Dates between 01.03.08 to 31.05.08
2 for Dates between 01.06.08 to 31.08.08
3 for Dates between 01.09.08 to 30.11.08
Thanks again and I am excited about your suggestions
Assuming those dates are recognised by Excel as dates (they wouldn't with my Regional Settings as Iam in the UK) then I think the absoulte simplest way of doing this is