Hi I have a spreadsheet where my column B contains the date of occurrence or data entry. i then wish to count the number of entries by month on a monthly basis. IE. if I have 4 data lines for the month of Jan, and 6 for the month of Feb, I would expect 4 and 6 to be my answers. ideally looking for a fx code to calculate this. regards paul