Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a macro to track the number of students enrolled per month
I am new to Excel and currently working on a spreadsheet to track the number
of students enrolled in our school per month. I already have all the enrollement dates listed for each student but need a macro that will take each date in that column, determine which month it falls in, and add it to other like dates for a total by month to be listed on a new spreadsheet -- islandgrl1984 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a macro to track the number of students enrolled per month
I would use the month function to break the month out of the date in a
separate column, then use the auto filter function to look at the data; or a pivot table to do the reporting if you are feeling adventurous. Boatman "islandgrl1984" wrote: I am new to Excel and currently working on a spreadsheet to track the number of students enrolled in our school per month. I already have all the enrollement dates listed for each student but need a macro that will take each date in that column, determine which month it falls in, and add it to other like dates for a total by month to be listed on a new spreadsheet -- islandgrl1984 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Converting Month Number to Month Text Abbreviation | Excel Worksheet Functions | |||
track sales history by month for several years | New Users to Excel | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
I'm looking for a template to track work accomplishments by month. | Excel Discussion (Misc queries) |