Hi
I want to analyse my data according to date, in categories I have assigned. So, for entries where the date is between the range 01/02/10 and 02/05/10, (for example) they would be catagory 1. I've been attempting to us equeries and extract the data according to its date into seperate sheets. However, I would also like to analys eit all together. Basically, I would like a field which has categories 1-9 depending upon which date range the entry falls into. Does anybody have any ideas?
Thanks
Jess