Need help trying to work out how to get my spreadsheet to work out how many jobs were opened in a month.
I have column A as the date the job was initiated using date format of 14-FEB-10 (DD-MMM-YY). On Worksheet 2 I would like to have the number of jobs to be displayed automatically for each month.
Can someone provide me with a formula?
Greatly appreciated.
Bookmarks