I have a date column which is labeled "Date Assigned" and I want to total the number of occurrences of a certain month (which represents how many files I assigned that month) only if it's in the current year.
I've made a pick list of all the months and I want to be able to pick month and have it calculate the number of occurrences of that month in that column if we are in the current year.
I tried doing this but it didn't work. I must not be using the year or today functions correctly
I'm using excel 2007