	AllExperts > Excel
	Search

About Philip Buckley
Expertise
In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.

Experience
I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.

Education/Credentials
MBA from the Crummer Graduate School of Business at Rollins College.

You are here: Experts > Computing/Technology > Microsoft Software > Excel > Excel

Excel - Excel

Expert: Philip Buckley - 10/4/2009

Question
I have a column of dates (Month, Day and Year) and want to have excel tell me how many of dates there are in a given month. That is how many dates show October as the month then how many show November etc.

Answer
1. For the column with the dates, make sure the column has a header labeled "Date" in cell "A1" with the data starting in cell "A2"
2. Label the next column over "Month" in cell "B1"
3. In cell "B2" type "=MONTH(A2)"

This will put the month in numerical form into cell "B2"

4. Copy cell "B2"
5. Paste down starting in cell "B3" and ending with the last date from column "A"

This will put the month in numerical form into column "B" for every date in column "A"

6. Click on the data with your mouse.
7. Select "Data" from the main menu
8. Select "PivotTable and PivotChart Report..."

This will bring up the "PivotTable and PivotChart Wizard"

9. Select "Next"
10. In the range section select columns "A" and "B"
11. Select "Next"
12. Select "Layout"
13. Drag the "Month" tile to the "Row" section
14. Drag the "Date" tile to the "Data" section

The "Data" section should now say "Count of Date" If it does not, double click on this tile and select "Count" and then "OK"

15. Select "OK"
16. Select Finish

This will give you a PivotTable that counts the number of dates for each month.

Add to this Answer Ask a Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here