# Thread: A Better Way to Calculate (Excel 2002)

1. ## A Better Way to Calculate (Excel 2002)

I apologize is this shows up a second time. I posted once and it did not appear to get posted.

In the attached sheet there are a number of interview dates. In reality the sheet actually covers three months. What the Manager was looking for was the number of interviews on each date. I used a countif formula at the end of each date. Obviously this was time consuming but as it was a rush job, I had to come up with some figures. There must be a better way. Correct?

Once imported from a specialized program, all interview dates stretched down column A for a number of rows. Is there a method to have all of January's information appear in columns A through to the last day in January, and then below the January data have February's data placed from column A through to the last day in Feb; followed by March?

Note that the number of interviews per day could be as few as 10 or more than 50.

Thanks

Thanks

2. ## Re: A Better Way to Calculate (Excel 2002)

In D1 enter:
1/4/2005

In D2:
+D1+1
Copy D2 to D3: D10 (gets the dates you nee, expand as needed)

In E1:
=COUNTIF(A:A,D1)

Copy E1 to E2:E10

Steve

3. ## Re: A Better Way to Calculate (Excel 2002)

You did post it before - in the FrontPage forum, in <post:=547,839>post 547,839</post:>. I have now locked that thread, with a link to this one.

4. ## Re: A Better Way to Calculate (Excel 2002)

Boy, I must be sleeping. Sorry.

5. ## Re: A Better Way to Calculate (Excel 2002)

Thanks.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•